Permanently changing the default excel date format from dd-mmm to mm/dd/yy for all future files.

Microsoft

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!

1 Reply

@zookjones Check the regional (date) settings on your computer. Excel follows whatever you have specified there.