Default Date Format

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Under date formating, the default option (the one with
the * at the top of the list) has recently changed from
*3/14/2001 to *3/14/01 (4 digit year to 2 digit year).
How do I ensure that it is 4 digits vs 2 digits? This
messes up formating in other sheets which I don't want to
go back and redo.
 
That is based on the date format specified in your OS settings. Go to
your Control Panel, open Regional and Language Options, select the
Regional Options tab if not already selected, click on Customized,
select the Date tab, and change the Short date format to M/d/yyyy, or
MM/dd/yyyy, whichever you prefer. Apply it. You should now see the 4
digit year at the top with an *.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Date Format 1
Access Running Balance in Access 1
Date in cell keeps adding the current year. 6
Excel date formats 2
MM/YY Formatting date Entry AND Display 2
VBA Macro change column contents 4
Converting Date to Julian 4
Windows 10 Activate windows now message 3

Back
Top