Excel TEXT Function Generator
Format a number or date as text using a format code, for labels and joined strings.
TEXT
Format a number or date as text using a format code, for labels and joined strings.
The number or date to format.
In quotes. Try "#,##0.00", "0.0%", "yyyy-mm-dd", or "$#,##0".
=TEXT(A2, "yyyy-mm-dd")Worked Example
Joining a date into a sentence, where plain concatenation would show the serial number.
="Invoice dated " & TEXT(A2, "d mmmm yyyy")Returns: Produces "Invoice dated 5 August 2026" instead of "Invoice dated 46238".
Checks Before You Paste
- •TEXT returns text, not a number. The result will not sum, and it sorts alphabetically - so format for display only, and keep the underlying value in its own cell.
- •Common codes: "#,##0.00" for two decimals with separators, "0.0%" for a percentage, "yyyy-mm-dd" for an ISO date, "mmmm" for a full month name, "$#,##0" for whole currency.
- •Format codes are locale-dependent. A workbook written with "yyyy-mm-dd" opens correctly elsewhere, but codes typed in a non-English Excel may use different letters for year and day.