Forum Discussion
Setting default date style for all future worksheets
I'm in the U.S. working in U.S. English. My Windows 10 Build 1809 system date defaults are: Wednesday, March 11, 2020 (DDDD, mmmm d, yyyy) 3/11/2020 (m/d/yyyy) Every time I enter a date in a n...
Hello EricJToll,
Perhaps changing your short date and long date settings in "Region" section of Control Panel would solve your issue.
Nope, if to enter 4-digits date like 3/11, Excel by default doesn't show the year component, independently of regional settings. It will be shown as mm/dd even if the short date is mm/dd/yy. Assuming we didn't apply the date format to the cell before.
I don't remember I've seen the workaround.
