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?
Formatted column A as desired, see the inserted file.Here are instructions from Microsoft on how to change the date.
I would be happy to find out if I could help.
I know I don't know anything (Socrates)