Can you re-import your data, and this time tell Excel to format it as date,
indicating what the format is? That'd be by far the fastest and least
error-prone approach


"Jesse" wrote:

I've converted an old database into an Excel spreadsheet and have about 5
columns containing hundreds of rows of dates. The dates were converted to a
"General" format. There are a mixture of 1 and 2 digit month and day formats.
All the years are 4 digit. (332001, 9111999, etc.). How can I convert these
numbers to a DATE format (mmddyyy)?