Forum Discussion
turn off Excel date system 1900 and 1904?
Hello, I have issue with calculating AGE in my data set. More precisely, I have dates of incorporation, some of them have format dd/mm/yyyy, but some of them are only years e.g. 1967 which transform...
Hi Pavel,
Actually, you can’t turn off the date system, but you can change the cells format that include years only.
Just switch the format for that cells to General, or highlight them and hit CTRL + Shift + ~