How do I convert DD/MM/YYYY that Excel reads as MM/DD?

In Text to Columns, choose the DMY order under the Date format. Tellsheet has a Day-first switch that reads DD/MM/YYYY correctly and deterministically, without silently swapping day and month.

DATEVALUE(text) returns the Excel serial number for a date written as text, e.g. =DATEVALUE(A2). Format the result cell as a date to display it. It follows your regional settings, so ambiguous day-first data can still misread.

Home › Excel Guides › Convert Text to Date in Excel

How to Convert Text to Date in Excel

Turn date-like text into real, sortable Excel dates — and fix the day-first DD/MM/YYYY data that Excel silently reads the wrong way round.

Last updated: August 2026

Text		Real date	Sortable?
2026-03-04	→	04 Mar 2026	Yes
13/12/2026 (day-first)	→	13 Dec 2026	Yes
Mar 4, 2026	→	04 Mar 2026	Yes

How to tell if a date is really text

Text dates usually sit left-aligned in the cell (real dates align right), and they won't sort chronologically or work in date math. A quick check: =ISNUMBER(A2) returns FALSE for a text date.

Method 1 — Text to Columns → Date

Select the column of date text.
Go to Data → Text to Columns, click Next twice.
Under Column data format, choose Date and pick the order — DMY for day-first data, MDY for month-first.
Click Finish. Excel now stores real dates you can sort and calculate on.

Method 2 — DATEVALUE / VALUE formulas

=DATEVALUE(A2) returns the date serial number; format the result cell as a date.
For ISO text like 2026-03-04, =VALUE(A2) also works.
Heads-up: both follow your regional settings, so ambiguous 01/02/2026 can still be read as the wrong month.

The 1-click way — Tellsheet's Convert Text to Date

Select the column, click Convert Text to Date, and flip on Day-first if your data is DD/MM/YYYY. Tellsheet parses ISO, slashed, and month-name dates deterministically — no reliance on Excel's regional guesswork — and leaves anything it can't confidently read untouched. You get a preview and it's fully revertable.

Frequently asked questions

Why won't Excel recognise my dates?

They're stored as text (usually left-aligned), common with imported CSVs and day-first formats. Convert them with Text to Columns → Date, DATEVALUE, or Tellsheet's Convert Text to Date.

How do I fix DD/MM/YYYY that Excel reads as MM/DD?

Choose the DMY order in Text to Columns, or use Tellsheet's Day-first switch, which reads DD/MM/YYYY correctly and deterministically instead of silently swapping day and month.

Can I convert a whole column of mixed formats at once?

Yes. Tellsheet's Convert Text to Date (and Fix Dates) handle ISO, slashed, and month-name formats in a single pass and skip cells that aren't dates.

Related Excel guides

Fix your dates in one click

Get Tellsheet and convert text to dates, split names, remove duplicates and more — inside Excel, with a preview before every change.

Get Tellsheet free See pricing