excel

[ritainorbost]

Hi,  I have a spreadsheet for my blood pressure.  The first column is date, but I don't want it to show the full date,  I only want dd/mm shown as 22/7  The latest 3 entries have been altered to dd/mm/yy.  How do I get it to show exactly what I type?

[#2]

@ritainorbost 

Formatted column A as desired, see the inserted file.
Here are instructions from Microsoft on how to change the date.

https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db...

I would be happy to find out if I could help.

Nikolino

I know I don't know anything (Socrates)