G
Guest
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)?
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)?