corrupted date conversion

  • Thread starter Thread starter namsilat
  • Start date Start date
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?
 
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
 
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.
 
Back
Top