How to convert a date to text in Excel

TEXT with yyyy-mm-dd

Excel stores every date as a number: the count of days since January 1, 1900. December 3, 2026 is 46359. The date you see is just a format on that number. TEXT applies a format and hands back the result as text, so it can go into a file name, a sentence, an ID or a system that wants a fixed layout.

yyyy-mm-dd (the ISO 8601 layout) is the best choice for anything a computer reads: it is unambiguous in every country, and text in that shape sorts in date order. Use yyyymmdd, which gives 20261203, when you need it with no separators, for example in invoice or batch numbers.

Other date formats you can use

The format code describes the layout. d is the day, m the month and y the year; repeat the letter to get longer forms. Here is what each gives for the due date in D2:

"mmmm d, yyyy" gives December 3, 2026. "d mmm yyyy" gives 3 Dec 2026. "dd/mm/yyyy" gives 03/12/2026 and "mm/dd/yyyy" gives 12/03/2026. "dddd" gives Thursday, and "ddd, mmm d" gives Thu, Dec 3. Any other characters, such as commas, spaces, hyphens and slashes, appear exactly as typed.

Pick the layout your reader expects, and spell the month out when the text goes to people in other countries. 03/12/2026 is March 12 to an American and 3 December to most of Europe; Dec 3, 2026 cannot be misread.

Why joining a date shows 46359

You build a reminder line with & and the date turns into a five-digit number. The & operator joins values as text, and it uses the underlying value of the date, not the format you see in the cell. So the 46359 behind December 3, 2026 is what lands in the sentence.

CONCAT and CONCATENATE do the same thing, and so does TEXTJOIN. Changing the cell format of D2 does not help, because the join never looks at the format.

Fix: wrap the date in TEXT inside the join

Put TEXT around the date reference and choose the format you want in the sentence. The rest of the formula is unchanged. This also works for amounts: TEXT(E2,"$#,##0") keeps the thousands separator that & would otherwise drop.

To list several dates in one cell, combine TEXT with TEXTJOIN. In Excel 365 and Excel 2021, =TEXTJOIN(", ",TRUE,TEXT(D2:D4,"mmm d")) gives Dec 3, Nov 19, Dec 9. For today's date in a line, use TEXT(TODAY(),"mmm d").

Dates with times: m means minutes after h

Column F holds a date and a time. Add the time codes after the date codes: h or hh for hours, mm for minutes, ss for seconds, and AM/PM for a 12-hour clock. TEXT(F2,"h:mm AM/PM") gives 2:35 PM.

The letter m does double duty. Excel reads it as minutes only when it comes right after h or hh, or right before ss; anywhere else it means the month. TEXT(F2,"mm") on its own gives 11, the month, not 35. If you only want the date, leave the time codes out and the time part is simply dropped from the text.

Text dates sort alphabetically, and other side effects

The result of TEXT is text, not a date. You cannot add days to it, it will not group by month in a PivotTable, and it sorts letter by letter. Formatted as "mmm d, yyyy", the due dates sort with December before January and November last, because D comes before J and N.

So keep the real date column for sorting and calculating, and use TEXT only in the column or cell you display or export. If you do need text that sorts correctly, use yyyy-mm-dd: =SORT(TEXT(D2:D6,"yyyy-mm-dd")) sorts in true date order. To turn the text back into a date later, see the guide on converting text to dates.

Locale traps, and converting a whole column without formulas

Format codes are language-specific. A German copy of Excel expects JJJJ for the year and TT for the day, a French one aaaa and jj. A TEXT formula written with English codes can give wrong results when someone opens the file with Excel set to another language. To force English month and day names, add a locale tag in front of the code, such as "[$-409]mmmm d, yyyy". For an ISO date that ignores language completely, build it from numbers: =YEAR(D2)&"-"&RIGHT("0"&MONTH(D2),2)&"-"&RIGHT("0"&DAY(D2),2) gives 2026-12-03 on any system.

Changing the cell format to Text (Ctrl+1) does not convert the date. The value is still a number, so the cell shows its serial number instead. To replace a column of dates with text permanently, convert with TEXT in a helper column, then paste the results over the originals as values.

1. In an empty column, enter =TEXT(D2,"yyyy-mm-dd") and fill it down.
2. Copy the new column.
3. Right-click the first original date cell and choose Paste Special > Values.
4. Delete the helper column. The cells now hold text, aligned to the left.