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?

On Thu, 24 May 2007 20:53:40 -0400, namsilat <(E-Mail Removed)> wrote:

>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?

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

This is an easy fix. Try Format -> Cells -> Date.

HTH,
Barb Reinhardt

"namsilat" wrote:

> 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?
>
>

For clarification..............

Excel treats all dates as serial numbers starting at Jan 0, 1900

For more on this see Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 20:53:40 -0400, namsilat <(E-Mail Removed)> wrote:

>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?

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.