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.