excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1537584%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537584%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%20I%20have%20a%20spreadsheet%20for%20my%20blood%20pressure.%26nbsp%3B%20The%20first%20column%20is%20date%2C%20but%20I%20don't%20want%20it%20to%20show%20the%20full%20date%2C%26nbsp%3B%20I%20only%20want%20dd%2Fmm%20shown%20as%2022%2F7%26nbsp%3B%20The%20latest%203%20entries%20have%20been%20altered%20to%20dd%2Fmm%2Fyy.%26nbsp%3B%20How%20do%20I%20get%20it%20to%20show%20exactly%20what%20I%20type%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1537584%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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?

1 Reply

@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)