software

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)
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-Proquot;lrl0870quot; wrote:

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