Pinterest Pixel

Turn Text Dates To Excel Dates With Text To Columns

Whenever you import data from your company’s server, ERP system or any other source for that matter,... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Turn Text Dates To Excel Dates With Text To Columns | MyExcelOnline Turn Text Dates To Excel Dates With Text To Columns | MyExcelOnline

Whenever you import data from your company’s server, ERP system or any other source for that matter, the Dates usually come in a TEXT format.

I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with.

Turn Text Dates To Excel Dates With Text To Columns | MyExcelOnline
Download excel workbookText-to-Columns-One-Click.xlsx

STEP 1: Let’s confirm that the Dates are in TEXT format by including the ISTEXT function.

A TRUE means that it is a TEXT format:

Turn Text Dates To Excel Dates With Text To Columns

STEP 2: Now that we know that our Dates are in TEXT format we can select the Dates column

Turn Text Dates To Excel Dates With Text To Columns

STEP 3: Go to Data > Text to Columns > Finish

Turn Text Dates To Excel Dates With Text To Columns

This will turn the TEXT Date into an Excel Date!  How quick was that?!?!?!

Turn Text Dates To Excel Dates With Text To Columns

If this does not fix your dates then you can use other methods to clean up that sticky, stubborn TEXT date:

Text To Columns: Dates

Turn Text To Values With Paste Special Values

Top Excel Data Cleansing Techniques

 

See also  Row Differences

 

THIS TIP WAS INSPIRED BY JORDAN GOLDMEIER ON THE FOLLOWING EXCEL TV EPISODE:

Turn Text Dates To Excel Dates With Text To Columns

If you like this Excel tip, please share it
Turn Text Dates To Excel Dates With Text To Columns | MyExcelOnline Turn Text Dates To Excel Dates With Text To Columns | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...