data formatting
I formatted my cell to a dd/mm/yy format. On my old computer, I used to be
able to enter dec 5 in a cell and it would automatically change it to
05/12/04. Now on my new computer when I enter dec 5 in a cell it gives me
01/12/05. How can I get it to enter the right day and year in a cell
without actually having to write the year in?
|