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)