Microsoft Excel Hints and Tips
Question
I have exported a report to Excel from another application, but the dates have
been exported as text. Is there a way to change the text into a date - with the
correct date serial numbers so that I can sort my report in date order ?
Solution
You can use the DATEVALUE function to return the serial number of the
text date, and then change the cell format to a date.
Return to Excel Exchange homepage.