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. Anyway to change this?
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. Anyway to change this? Read More