Forum Discussion
Excel 2029 rule - How to stop it from calculating numbers above 29 to the 20th century
Hello, I have an employee who is having an issue with converting numbers in an Excel column to dates. Any number ending above 29 is converted to 20th century i.e 33 is 1933 and so forth. I read a...
SeanR87
As I understood the year is two last digits of the number and it shall be in 21st century. Thus
33 => 2033
23 => 2023
etc
What exactly is wrong?
SergeiBaklan Yes that is correct but if you look at the year you have for a few of the values is it wrong.
Could you please give the concrete example? With that I will try to correct. I really don't see what is wrong.