Forum Discussion
George Ritter
May 21, 2018Copper Contributor
Entering Dates
I formatted a column as date, like this: 30-Mar When I enter a date in 1930 I enter like, 30-Mar-30 and then the cell shows 30-Mar and the edit box at the top of the sheet says 3/30/1930. Fine! How...
Matt Mickle
May 21, 2018Bronze Contributor
It looks like this is a windows setting. James Sturms was kind enough to point me to the correct article for documentation:
https://support.microsoft.com/en-us/help/214391/how-excel-works-with-two-digit-year-numbers
If you want to change this setting you can go to Control Panel > Clock Language and Region > Change Date Time or Number Formats > Additional Settings > Date