Forum Discussion
Dates changed to number
I have a 10-year-old excel sheet database. Whilst working on it, the dates of more than 1000 entries suddenly changed from DD/MM/YYYY to random numbers. When I click on the cell itself, the correct d...
Thanks jukapil
Unfortunately that didn't work.
I copied 1 into a cell right beneath the dates column and then followed the steps you listed but nothing happens.
It's worth noting that the format tab does show "Date" and not "Number" or "General". Which is why it's odd. The format is "Date" already, the function tab shows the correct date in the correct format, but the cell shows a string of numbers.
Any ideas?
aie_102000 Can you share few samples in sample file. I may help upon it