Convert serial numbers to dates

[lrl0870]

I exported data from an application and the date column is formatted as
serial numbers, i.e.: 37935.5140046296

When I click on one of the serial number cells, the correct date/time format
shows in the formula bar (11/10/2003 12:20:10 PM).

How do I get the date format that's showing in the formula bar to show in
the actual cells? (without having to manually copy/paste...there are 2600
rows, each with a different date)

[Ron Coderre]

Try this:

First, make sure the values are numeric, not text:
Select the cells
Data|Text-to-columns
Click the [Finish] button...that should do it.

Then, change the serial numbers to a date format
Select the cells
Format|Cells|Number tab
Category: Date
Type: Select an appropriate date format

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"lrl0870" wrote:

> I exported data from an application and the date column is formatted as
> serial numbers, i.e.: 37935.5140046296
>
> When I click on one of the serial number cells, the correct date/time format
> shows in the formula bar (11/10/2003 12:20:10 PM).
>
> How do I get the date format that's showing in the formula bar to show in
> the actual cells? (without having to manually copy/paste...there are 2600
> rows, each with a different date)
>
>