Please help, dates changes to numbers

August 23, 2013 at 08:49:05
Specs: Windows 7
Hi, I have a column in an excell sheet where the dates are changed to numbers. For example, August 1, 2013 is changed to 41487. I tried changing the format to date but it is not changing. In the cell itself, it is showing 41487 but in the formula bar, it is showing 01-Aug-2013. I can't figure out what's wrong. I will appreciate any help, thanks.

message edited by milesdream

See More: Please help, dates changes to numbers

Report •

August 23, 2013 at 09:30:33
What version of Excel, please?

Format dates for Cells:

Report •

August 23, 2013 at 09:52:59
It's version 2010. What I don't understand is in the formula bar, the date is showing correctly but in the cell, it is showing differently. When I double click the cell, the date will show, then when I press enter, the numbers will show again.

Report •
Related Solutions

Ask Question