Forum Discussion
Permanently changing the default excel date format from dd-mmm to mm/dd/yy for all future files.
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?
I agree that is frustrating and stupid. I can imagine the entire microsoft community having to reformat every cell, every day, forever, and nobody cares. Why doesn't at least one MS developer stand up and fix this?