Jun 20 2022 06:24 PM
For as long as I can remember, I have had to manually reformat dates in excel from the default 20-Jun (dd-mmm) format to something that people actually use (never seen dd-mmm anywhere but as default in excel).
Is there a way to never have to do this again by changing the default in all new .xls files I create? Not sure how the current default was chosen, but not something any person/company/business unit I have ever worked with/in has used.
I would be forever thankful if I didn't have to manually reformat again :). Thank you!
Jun 20 2022 10:17 PM
@zookjones Check the regional (date) settings on your computer. Excel follows whatever you have specified there.
Sep 12 2022 01:17 AM - edited Sep 12 2022 01:17 AM
No, this does not do it. Excel is hardwired to convert anything that resembles a date with day and month to dd-mmm. The regional / date settings have nothing to do with it.
You can force it to a halfway sensible date format like dd/mm/yyyy (mm/dd/yyyy is not anything like sensible) by entering dates that way e.g. 12/09/2022. But that forces you to type in all the redundant info that you could avoid if you could just type in the date in the simplest format (12/9).
This has been a huge annoyance for me for the entire 25+ years I have been using Excel.
WTF can't they just give users a choice?
Sep 12 2022 03:06 AM - edited Sep 12 2022 03:07 AM
@Andy Owen I believe you are right, Though, personally I'm not bothered by this, but you could always notify MS via the Feedback option.