Convert a number or date to text in a specific format.
Syntax
TEXT(value, format_text)Arguments
valuerequired
The number or date to format.
format_textrequired
A format code, e.g. "$#,##0.00" or "yyyy-mm-dd".
TEXT formats a value as a string using a format code — for currency, dates, percentages, leading zeros, and more. Essential when concatenating numbers/dates into readable labels.
=TEXT(1234.5, "$#,##0.00")→$1,234.50Formats a number as currency text.
=TEXT(A2, "yyyy-mm-dd")→2026-06-19Formats a date.
Pick the value
Reference the number or date.
Write the format code
Use the same codes as custom cell formatting.
Concatenation drops cell formatting — wrap the number in TEXT(value, format) to keep it.