Excel Date to String: Format Dates as Text

How-to basics · Updated November 18, 2026

To convert an Excel date to a text string, use the TEXT function: with a date in A2, enter =TEXT(A2,"yyyy-mm-dd"). If A2 contains March 8, 2024, the result is the text string 2024-03-08; the formula formats the date and returns text rather than another date value.

What Excel dates and strings mean

Excel normally stores dates as numbers, called serial values, and displays those numbers using a date format. The date value lets Excel sort dates chronologically, calculate elapsed time, and use dates in formulas. A string, by contrast, is text: it can look like a date to a person, but Excel does not treat it as a date for date arithmetic.

This distinction explains why changing a cell’s appearance is not the same as converting its contents. Applying a date format such as yyyy-mm-dd changes how a numeric date is displayed; the underlying value remains numeric. The TEXT function takes a numeric value and a format code, then returns characters as text.

Excel for Microsoft 365 on Windows usually uses the 1900 date system for new workbooks. Some workbooks use the 1904 date system, so the same serial number can represent a different date in those workbooks. In ordinary use, format the actual date cell rather than copying serial numbers between workbooks and assuming they have the same meaning.

Convert a date with TEXT

With the date in A2, use =TEXT(A2,"mmmm d, yyyy"). For March 8, 2024, this returns March 8, 2024 as text. The first argument is the date or number to format; the second is a quoted format string. You can type the formula into another cell and fill it down for the rest of a column.

Choose a format that suits the destination. Common examples include:

  • =TEXT(A2,"yyyy-mm-dd") returns 2024-03-08 for March 8, 2024.
  • =TEXT(A2,"m/d/yy") returns 3/8/24 for that same date.
  • =TEXT(A2,"mmm d, yyyy") returns Mar 8, 2024.
  • =TEXT(A2,"dddd") returns Friday for March 8, 2024.

Each example assumes A2 contains the date March 8, 2024. The formula’s result is text, even when the characters resemble the date format you would normally see in a cell. The ISO-style yyyy-mm-dd format is useful for labels, filenames, and data exchanges because its year-month-day order is less likely to be mistaken for a different regional date order.

Format codes are not quite the same as the labels used in every regional date setting. In common Excel date formats, d represents the day, m the month, and y the year; repeated letters control detail, such as dddd for the full weekday name or mmmm for the full month name. Excel interprets m as minutes in time contexts, so use a time-specific format such as h:mm when displaying hours and minutes.

Include dates in labels and combined text

A date used directly in a text-joining formula can turn into its serial number rather than the readable date shown in its cell. Apply TEXT to the date first so the label contains the intended characters. With A2 containing March 8, 2024, enter ="Due: "&TEXT(A2,"mmm d, yyyy"); the result is Due: Mar 8, 2024.

This approach works for report headings, messages, and descriptions. For example, if a start date is in A2 and an end date is in B2, a formula can format each one separately before joining them. With those dates in A2 and B2, use =TEXT(A2,"mmm d")&" to "&TEXT(B2,"mmm d, yyyy"). If A2 is April 1, 2024 and B2 is April 5, 2024, the result is Apr 1 to Apr 5, 2024. The formula creates a text label, not a date range Excel can calculate with.

For larger reports, it is often clearer to keep the original dates in their own columns and create a separate display column. That preserves the useful numeric dates while providing text for a specific export or label. Avoid overwriting the only copy of the original date until you are sure you no longer need date calculations or sorting.

Choose between formatting, TEXT, and static text

The right method depends on whether you need the date to remain useful for calculations, merely look a certain way, or become a fixed text value. These three outcomes are different:

  • Change appearance: Select the date cells and use Home > Number Format to choose a date format. The cells remain numeric dates.
  • Return formatted text: Use TEXT when a formula, label, or export needs a text string with a specific pattern. The result updates if the referenced date changes.
  • Keep a fixed text result: Copy the formula results, then use Home > Paste > Paste Values. This replaces the formulas with their current displayed text.

Use a normal date format when you still need date arithmetic, chronological sorting, or date filters. Use TEXT when the value must be embedded in a sentence or made to follow a precise text pattern. Paste values only when you want to remove the formula dependency. Once a date has been converted to text, Excel may sort it alphabetically rather than chronologically, especially when the text uses month names or a month-first format.

Fill a column and preserve the result

For a list of dates, put the conversion formula in the first result row, then fill it down. For example, if dates are in A2:A100, place =TEXT(A2,"yyyy-mm-dd") in B2 and copy or fill the formula through B100. Each row refers to its corresponding cell in column A, so B2 displays the formatted text for A2 and B100 displays it for A100.

If another system needs fixed text rather than formulas, copy the completed results and paste values into the destination cells. Check that the output column still contains the expected strings before deleting or changing the source dates. If the destination is another workbook, paste values there as well when you do not want formulas pointing back to the original workbook.

One useful check is to select a converted cell and inspect the formula bar. A cell showing a formula such as =TEXT(A2,"yyyy-mm-dd") is still formula-driven. After pasting values, the formula bar should show the text result itself. Excel may display a green indicator for text that resembles a number or date; that warning does not by itself mean the text is wrong.

Send date strings to CSV and other systems

Converting dates to text is common when preparing data for a CSV file, a database import, a web form, or another application with strict date requirements. Before converting, check the receiving system’s accepted format. A value such as 03/08/2024 is ambiguous: it can mean March 8 or August 3 depending on regional conventions. A format such as 2024-03-08 is much less ambiguous, but the receiving application’s requirements still take precedence.

For a CSV handoff, first create the desired text in a separate column, then verify several rows, including dates near the start and end of the range. Choose File > Save As and select CSV UTF-8 (Comma delimited) (*.csv) in the file type list if UTF-8 text is appropriate for the recipient. A CSV file stores plain values, not Excel formulas, formatting, or multiple worksheets; saving in CSV format applies to the active sheet. Reopen or inspect the saved file in a text editor or the receiving application to confirm the dates and separators look right.

CSV export can also be affected by regional settings and the way Excel writes displayed values. If the format is essential, do not assume that a date’s appearance in the worksheet guarantees the exported text will meet every external system’s rules. Check the actual file. Keep a copy of the workbook with the original date values in case the import needs to be repeated or corrected.

Common conversion problems

  • The result is a number or an error: Confirm that A2 contains a valid Excel date, not text that only looks like one. Text dates may need to be parsed or converted before formatting. A cell’s alignment or appearance alone does not prove its underlying type.
  • The formula displays as text: The destination cell may be formatted as Text, or the formula may have a leading apostrophe. Change the cell to General, then re-enter the formula.
  • The month and day are reversed: The source may have been interpreted according to a different regional date order. Resolve the original date correctly before creating a string; formatting cannot repair a date value that was parsed incorrectly.
  • The output changes after editing the source: That is expected for a formula result. Use Paste Values if you need a fixed snapshot.
  • The string sorts strangely: Text sorting follows character order, not date order. Keep a numeric date column for chronological sorting, or use year-month-day text where a text-only sort must follow calendar order.

A related misconception is that changing a cell’s number format converts a date into text. It does not: it changes display only. Conversely, TEXT does return text, but that makes the result less suitable for date calculations. Keeping both a real date column and a formatted-text column is often the safest design.

Frequently Asked Questions

How do I convert an Excel date to text without changing its appearance?
Use a separate cell with =TEXT(A2,"yyyy-mm-dd"), adjusting the format code to match the required appearance. The original date cell remains unchanged.

Why does Excel show a date as a number?
Excel stores dates as serial numbers and relies on cell formatting to display them as dates. Apply a date format to show the date, or use TEXT if you specifically need a text result.

Can I convert a whole column of dates at once?
Enter a TEXT formula for the first row, fill it down alongside the date column, and paste values if fixed text is required. Verify that the source cells are actual dates.

How do I join a date with words in Excel?
Format the date inside the joining formula, for example ="Sent "&TEXT(A2,"mmmm d, yyyy"). This prevents Excel from inserting the underlying serial number into the sentence.

Will a date converted to text still work in date calculations?
Not reliably as a date value. Keep the original numeric date for calculations and use a separate text result for display, labels, or data export.

Practical rule of thumb

Keep dates numeric whenever Excel needs to calculate with them. Use TEXT when a particular string is required, choose an unambiguous pattern for data exchange, and preserve the original dates until the exported or pasted result has been checked. That simple separation avoids most confusion between a date’s value and the way it looks on screen.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.