Convert Dates to Text in Excel: Formulas and Methods

Formulas & functions · Updated November 19, 2026

If the dates are real Excel dates in A2:A1000, enter =TEXT(A2,"mmmm d, yyyy") in B2 and fill it down; the result for a date of March 7, 2025 is the text March 7, 2025. This is the most dependable way to convert many dates while choosing exactly how they should look.

Why Excel dates can look like text already

Excel usually stores a date as a serial number and displays it using a date format. The stored value represents a day in Excel’s date system; the cell’s number format controls whether it appears as 3/7/2025, March 7, 2025, or another pattern. Changing the display format changes how a date looks, but it does not turn the underlying value into text.

That distinction matters when preparing a file for export, creating a fixed label, or combining a date with other words. A true date can be sorted chronologically, used in date calculations, and recognized by many spreadsheet tools. Text that looks like a date is just characters. It may be suitable for a report or a system that specifically requires text, but it is less useful for later calculations.

Before converting, check that Excel recognizes the source values as dates. A quick clue is alignment: dates and numbers are commonly right-aligned by default, while text is commonly left-aligned. Alignment can be changed manually, so it is only a clue. You can also temporarily apply a number format such as General; a true date will display as a number rather than its familiar date appearance.

Convert a date column with the TEXT function

TEXT converts a number into text using a format pattern. With dates in A2:A1000 and the first result going in B2, use =TEXT(A2,"mmmm d, yyyy"). If A2 contains March 7, 2025, the result is the text March 7, 2025. The formula refers to A2, so each row can return a formatted version of its corresponding date after you fill the formula down.

Choose the pattern to suit the destination. For a compact, unambiguous date, with the same source layout (dates in A2:A1000 and a formula in B2), use =TEXT(A2,"yyyy-mm-dd"). A date of March 7, 2025 returns 2025-03-07. The year-first, zero-padded pattern is often useful in file names, data exchanges, and lists that need to sort in date order as text.

For a weekday and abbreviated month, with dates in A2:A1000 and the result formula in B2, use =TEXT(A2,"ddd, mmm d"). March 7, 2025 returns Fri, Mar 7. It is a readable label, but it leaves out the year, so it is less suitable when dates from different years appear together.

In Excel format patterns, m represents a month when used in a date pattern, while d represents the day and y the year. Repeating a letter changes the display: mmmm gives the full month name, ddd gives an abbreviated weekday, and yyyy gives a four-digit year. The exact month and weekday names can depend on your regional settings.

Fill the formula through a large list

After entering the formula in B2, select B2 and use the fill handle—the small square at the lower-right corner of the selection—to copy the formula down. If column A has a continuous block of dates with no gaps in the adjacent column, double-clicking the fill handle usually fills the formula to the end of that block. Check the last few rows afterward, especially if the source list contains blank rows or neighboring data ends at a different point.

You can also select the destination range and fill it in one operation. For dates in A2:A1000, enter the formula in B2, select B2:B1000, and use Home > Fill > Down. On Windows, Ctrl+D fills down; in Excel for Mac, Control+D is the corresponding fill-down shortcut. Excel for the web also has the Home > Fill > Down command, though available keyboard shortcuts can depend on the browser and its own shortcuts.

Keep the output in a separate column while checking the conversion. This preserves the original date values, makes it easier to compare results, and lets you change the text pattern without having to recover the source. If the list is an Excel table, entering the formula in the first row of a new table column will generally populate the calculated column automatically.

Turn formula results into fixed text

A TEXT formula returns text, but it remains a formula linked to the original date. If you need a fixed result—for example, before deleting the source column—copy the converted cells and paste their values over themselves or into another location. In Excel for Microsoft 365 on Windows, use Home > Paste > Values from the Paste menu. Excel for Mac provides a Values paste option in its Paste menu as well.

After pasting values, click a few cells and inspect the formula bar. A fixed text result should show the displayed characters rather than a formula beginning with an equals sign. Be cautious about overwriting the original date column: first make sure the converted output is correct and that you no longer need the numeric dates for sorting, filtering, or calculations.

If you paste text values into a destination that has an unusual number format, the destination format may affect what you see. For a clean handoff, paste into a new column, check the result, and then save a separate copy in the format required by the recipient. Saving as CSV also removes workbook features and stores exported values as text in the file; it is not a substitute for keeping an editable Excel copy.

Choose a method that matches the task

  • Use TEXT formulas when you need a particular pattern, want repeatable results, or expect the source dates to change. The formula recalculates when its referenced date changes.
  • Change the cell format when you only want dates to look different inside Excel and still need them to behave as dates. Select the cells, open the Format Cells dialog with Ctrl+1 on Windows or Command+1 on Mac, and choose a date or custom format. This does not convert the values to text.
  • Paste values after using TEXT when the final output must be fixed text rather than a live formula.
  • Use Power Query for repeatable data imports or transformations that you will refresh, rather than manually applying a formula to each new batch.

These options solve different problems. If the goal is simply a more readable worksheet, changing the number format is usually better because the dates remain sortable and usable in calculations. If another system specifically requires strings, TEXT or a Power Query text conversion is more appropriate. Decide based on how the result will be used, not just how it appears on screen.

Convert dates in Power Query

Power Query is useful when the dates arrive in recurring files and you want to repeat the same cleanup steps. In Excel for Microsoft 365 on Windows, select a cell in the source table or range and choose Data > From Table/Range. If the data is not already a table, Excel prompts you to create one. In the Power Query Editor, select the date column and choose Transform > Data Type > Text, then choose Home > Close & Load to return the result to Excel.

Power Query changes the column’s data type within the query, so the loaded result is text rather than a live TEXT formula. The precise textual representation can depend on the query’s culture and the values’ interpretation. If your source has ambiguous dates such as 04/05/2025, confirm whether it means April 5 or May 4 before converting. In the editor, use the column’s data type options and locale-aware conversion where needed, then verify the output before loading it.

Power Query’s main advantage is refreshability: when you replace or add source data in the expected structure, you can refresh the query and repeat its transformation steps. It takes more initial setup than filling a formula down a one-time list. Excel for Mac and the web may not expose exactly the same Power Query capabilities or interface as Excel for Windows, so use the available Get Data or Power Query commands in your edition and confirm that the required transformation is supported.

Common conversion problems and fixes

The formula returns a number or an error. Confirm that the source cell contains a valid Excel date, not text that merely looks like one. If a date was imported as text, Excel may not interpret it consistently, particularly when day and month order is ambiguous. Convert or re-import the source using the correct regional interpretation before applying TEXT.

The month and day seem reversed. This is often a source interpretation problem, not a TEXT formatting problem. A value such as 03/04/2025 can mean March 4 or April 3 in different locales. Check the original file’s convention and use the correct locale when importing or parsing it; changing the output pattern cannot recover an interpretation that was already wrong.

The result changes when the workbook opens elsewhere. Month names and some date interpretations can be affected by regional settings. A numeric pattern such as yyyy-mm-dd is generally less ambiguous than a month name, though it is still text and should be checked against the receiving system’s requirements.

The converted values no longer sort as expected. Text usually sorts alphabetically, not by Excel’s date chronology. Zero-padded year-month-day text, such as 2025-03-07, sorts in calendar order when all values use the same pattern. Other patterns, such as March 7, 2025, do not reliably sort chronologically as text. Keep the original date column if date sorting or calculations may still be needed.

A formula result displays as a date or a serial number. TEXT itself returns text, but check that you are looking at the formula result and not the original column. If you pasted values and the destination displays unexpectedly, inspect the formula bar and the destination’s cell format. A custom number format changes display; it does not prove that a cell’s contents are text.

Frequently Asked Questions

How do I convert an entire Excel date column to text? Add a neighboring column, enter a TEXT formula for the first date, and fill it down through the data. Copy the results and paste values if you need fixed text. Keep the original column until you have checked the output and confirmed that you no longer need date calculations.

Does changing the date format convert dates to text? No. A date format changes how Excel displays the stored date value. Use TEXT or a data-transformation tool when the underlying result must be text; use cell formatting when you only want a different appearance.

How can I get a date like 2025-03-07? With the source date in A2 and the result in B2, use =TEXT(A2,"yyyy-mm-dd"). For March 7, 2025, the returned text is 2025-03-07. Fill the formula down for the rest of the date list.

Can I convert dates to text without a formula? Yes, if the conversion is part of a repeatable data import, use Power Query to change the column type to Text and load the results. Merely choosing a different number format is not a conversion. For a one-time conversion, a formula followed by Paste Values is usually more direct.

Will the converted text still work in date calculations? Not reliably. Text that resembles a date is not the same as an Excel date value, so date arithmetic, chronological sorting, charts, and some filters may not behave as expected. Retain a numeric date column for calculations and create a separate text column for labels or exports.

Keep a usable source copy

For most large lists, the safest workflow is to leave the original dates intact, create a TEXT formula in a new column, fill it through the complete range, and verify a few results—including dates near the start and end of the list. Then paste values only if fixed text is required. This keeps the conversion transparent and lets you revise the format without losing the dates Excel can calculate with.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.