Microsoft Excel Hints and Tips
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 ?
You can use the DATEVALUE function to return the serial number of the text date, and then change the cell format to a date.
Back to Questions Index
Return to Excel Exchange homepage.