Forum Discussion
Solved
Excel overrules Windows regional setting for two digit year translation
It is documented that as a rule, Excel will translate two digit dates either to the 1900's or the 2000' based on the breaking point 2029. So '30 will become 1930. With that year only 8 years in the ...
Default setting (1950-2049) in Windows 11 doesn't work from the box, we need first to "activate" it. Change on 1951-2050 or whatever you prefer. Apply. After that you may return back to 1950-2049 and apply again. It shall work now, 30 goes to 2030. Not necessary to restart Excel after the setting is applied.
For me - W11 and MS 365 for enterprise it doesn't work.
I clicked File > Optons > Advanced > When calculating this workbook and checked the Use 1904 date system box. Still short date 20/4/30 became 20 april 1930 i/o 2030.
Tried shutting down the workbook and then trying again (checked the box was still ticked), but no luck.
I clicked File > Optons > Advanced > When calculating this workbook and checked the Use 1904 date system box. Still short date 20/4/30 became 20 april 1930 i/o 2030.
Tried shutting down the workbook and then trying again (checked the box was still ticked), but no luck.
Default setting (1950-2049) in Windows 11 doesn't work from the box, we need first to "activate" it. Change on 1951-2050 or whatever you prefer. Apply. After that you may return back to 1950-2049 and apply again. It shall work now, 30 goes to 2030. Not necessary to restart Excel after the setting is applied.
Kipopstok , you are welcome.
Yes, Windows 10 lives with that issue.
- Hi Sergei, thanks. Incidentally I had already fiddled with the Windows setting just now. But I never thought to check back in Excel. You are right: in Windows 11 Excel does follow the Windows setting - if you 'activate it' as you suggested. If you do that, you don't need to check the 'Use 1904 date system' in the Excel sheet.
This doesn't solve the problem in Windows 10, but that problem will run out by end of 2025 anyway...