corrupted date conversion

N

namsilat

I have an excel file that was somehow corrupted. After Excel repaired
the file, almost everything was ok, except the dates. They were
somehow converted into numeric form. For example, May 18, 2007 was
displayed as "39220". Can someone suggest a quick macro that can
convert all the numbers back to the original date entry?
 
R

Ron Rosenfeld

I have an excel file that was somehow corrupted. After Excel repaired
the file, almost everything was ok, except the dates. They were
somehow converted into numeric form. For example, May 18, 2007 was
displayed as "39220". Can someone suggest a quick macro that can
convert all the numbers back to the original date entry?
Click to expand...

If you format those cells as date (format/cells/number/date) they will display
properly.
--ron
 
D

Don Franco

But you should be aware that there is also the optiion to use the 1904
format. This can complicate things.....especially using modules or so.
 
Top