Forum Discussion

EricJToll's avatar
EricJToll
Copper Contributor
Mar 10, 2020

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 new Excel spreadsheet, it shows up as 11-Mar. This has been going on for year, and Microsoft just won't change it. No one I know, nor have I seen this format in any news report, document, article, story, white paper, or spreadsheet in America displayed this way.

 

I have tried formatting the date across the entire spreadsheet on a blank spreadsheet and saving as a template. This causes all numeric entries to display as a date.

 

I have tried formatting the date "default" on a blank spreadsheet and saving as a template. Only cell A1 displays the date in the new default.

 

What do I have to do in order to have every spreadsheet I open default date displays to "m

excel
Formulas and Functions

3 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Mar 10, 2020

    Hello EricJToll,

     

    Perhaps changing your short date and long date settings in "Region" section of Control Panel would solve your issue.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 10, 2020

      PReagan 

      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.

Resources