Excel guide

How to Convert Text to Date in Excel (Dates Not Sorting)

Last updated: October 10, 2026 · 3 min read

You sort a column of dates and the order is wrong. Or a date formula shows an error. The reason is almost always the same: Excel keeps your dates as text, not as real dates. Here are three ways to convert text to dates. Start with Fix 1.

Fix 1

Convert text to date in the whole sheet with the free tool

  1. Open the Fix Date and Number Formats tool.
  2. Choose your Excel file.
  3. Pick the date format you want, for example MM/DD/YYYY.
  4. Click Run and save the cleaned copy.

The tool turns text like 3/4/2026, 2026-03-04 or March 4, 2026 into real dates that sort and calculate. Your original file stays as it is.

Fix 2

Convert text to date with Text to Columns

  1. Select the column with the text dates.
  2. Go to Data, Text to Columns.
  3. Click Next two times.
  4. Under Column data format, choose Date and pick the order, for example MDY.
  5. Click Finish.

MDY means month, day, year. This is the usual order in the US. Text to Columns works on one column at a time and changes it in place, so make a copy of the column first.

Fix 3

Convert text to date with the DATEVALUE formula

Put this formula in an empty column and copy it down:

=DATEVALUE(A2)

Careful: DATEVALUE reads the text with the date settings of your computer. The same text can give a different date on another computer.

You get a number like 46085 if the cell is not formatted as a date yet. That is how Excel stores a date. Select the new column, press Ctrl+1, choose Date and pick a format. Then copy the column and paste it back with Paste Special, Values.

Is it a text date or a real date? Quick check

  • By default, text dates sit on the left side of the cell. Real dates sit on the right.
  • The formula =ISNUMBER(A2) shows FALSE for text and TRUE for a real date.
  • Sorting puts 10/01/2026 before 2/1/2026. That is the sign of text.

Careful: 03/04/2026 means March 4 in the US and April 3 in most of Europe. Always check a few rows after the conversion.

Convert text to date in Excel: before and after

Before (text)After (real date)
March 4, 202603/04/2026
2026-03-0403/04/2026
3/4/202603/04/2026

Real dates sort in the right order and work in formulas.

Turn text dates into real dates in one click

The Fix Date and Number Formats tool runs on your own computer. Your file is never uploaded.

Questions about converting text to dates in Excel

Why do my dates not sort correctly in Excel?

The dates are text. Excel sorts text letter by letter, so 10/01/2026 can come before 2/1/2026. Convert the text to real dates first.

How do I convert a whole column of text dates?

Use the free Fix Date and Number Formats tool for the whole sheet, or Text to Columns on one column, or DATEVALUE in a helper column.

Why does DATEVALUE show #VALUE!?

Excel could not read the text as a date. Look for hidden spaces first. The Clean Whitespace tool removes them.

Why is my date a five digit number?

The conversion worked, but the cell has no date format yet. Press Ctrl+1 and choose Date.

More Excel guides

← All Excel guides