Convert a number or date to text in a specific format.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
TEXT(value, format_text)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")Result: $1,234.50
Formats a number as currency text.
=TEXT(A2, "yyyy-mm-dd")Result: 2026-06-19
Formats a date.
Concatenation drops cell formatting — wrap the number in TEXT(value, format) to keep it.