Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes.
Sometimes “Date” values are downloaded as “Text”, so you cannot sort in the periodic date format.
No worries! Text to Columns to the rescue!
Below I show you how to convert this “Text” data into “Excel friendly” data. Download the workbook to practice this cool trick!
NB: If the dates are not converting properly after you do the Text to Columns, it may be that your computer’s Region formats need changing.
Go to the Region settings in your Control Panel and make sure that the Short Date is in this format: dd/MM/yyyy
HELPFUL RESOURCE:
