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

DOWNLOAD WORKBOOK

Text to Columns - Dates3

HELPFUL RESOURCE:

MOTH-excel_expert470x63

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Extra Excel Table Styles The Excel Table Styles give a user a choice of different styles ranging from Light, Medium and Dark. There are over 50 choices depending on your favorite style or company standard but you are not only limited to those. You have extra Table styles in the Page Layout tab in y...
Conditionally Formatting A Drop Down List In a previous post I showed you how to Create a Drop Down List in a Table.    We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list. This is useful if you want to highlight when a job is completed, c...
Custom Number Formats in Excel A custom number format in Excel can have up to four different sections in the following order: Positive format; Negative format; Zero format; Text format   You can specify different format codes for each section as long as they are separated by a semicolon. So you ca...
Fix Incorrect Formatting Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically. Ever had the scenario where your data is formatted differently? Example: First names starting wit...