Forum Discussion
dduvernayFH
Jun 14, 2024Copper Contributor
Default years in Excel
Hi there - when typing 5/1/35 in Excel, it is returning 5/1/1935. I tested a few years, and until 5/1/29, the system will default to 2029, but as soon as I type in 5/1/30, it reverts to 5/1/1930. A...
HansVogelaar
Jun 14, 2024MVP
If you are on Windows:
Press Windows key+R to activate the Run dialog.
Enter or copy/paste
control international
into the box, then press Enter or click OK.
This activates the Region control panel.
Click Additional settings...
This activates the Customize Format dialog.
Activate the Date tab.
You can specify how two-digit years are interpreted here:
Don;t forget to click OK after changing the setting.