Forum Discussion
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...
It looks like you have to change the setting in the Date tab of the Customize Format dialog at least once for Excel to pick it up. So select - for example - 2048, then click OK. Next, select 2049 again and click OK again. Excel should now use this setting.
this worked great! thank you so much.