Excel Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-312501%22%20slang%3D%22en-US%22%3EExcel%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312501%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20January%209%2C%202019.%3C%2FP%3E%3CP%3EWhen%20I%20open%20a%20new%20workbook%2C%20go%20to%20cell%20A1%2C%20enter%201%2F9%2C%3C%2FP%3E%3CP%3Ethe%20cell%20shows%209-Jan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20change%20this%3F%3C%2FP%3E%3CP%3EI%20am%20NOT%20talking%20about%20the%20format%20cells%20path.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20declare%20how%20I%20want%20the%20date%20to%20be%20displayed%20by%20default%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-312501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312506%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312506%22%20slang%3D%22en-US%22%3EI%20thought%20I%20did.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312503%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312503%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3EMake%20sure%20to%20post%20this%20in%20the%20excel%20forum%20as%20well!%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722215%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F262652%22%20target%3D%22_blank%22%3E%40tlclear8W%3C%2FA%3E-%20I%20may%20be%20wrong%2C%20but%20I%20think%20the%20reason%20you%20are%20getting%20a%20lot%20of%20views%20and%20not%20many%20answers%20is%20that%20the%20only%20way%20to%20determine%20that%20is%20to%20use%20the%20%22Format%20Cells...%22%20-%26gt%3B%20%22Custom%22%20-%26gt%3B%20%22dd%2Fmm%2Fyyyy%22%20(or%20similar)%2C%20which%20you%20seem%20to%20have%20ruled%20out.%20Best%20regards%2C%20Tony%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Today, January 9, 2019.

When I open a new workbook, go to cell A1, enter 1/9,

the cell shows 9-Jan

 

How do I change this?

I am NOT talking about the format cells path.

 

How do I declare how I want the date to be displayed by default?

3 Replies
Highlighted
Hi!
Make sure to post this in the excel forum as well!

Adam
Highlighted
I thought I did.
Highlighted

@tlclear8W- I may be wrong, but I think the reason you are getting a lot of views and not many answers is that the only way to determine that is to use the "Format Cells..." -> "Custom" -> "dd/mm/yyyy" (or similar), which you seem to have ruled out. Best regards, Tony