TEXT
TextExcel 2007Format a number or date as text using a format code.
Syntax
TEXT(value, format_text)
Arguments
- value
- The number or date.
- format_text
- A format code in quotes, e.g. "0.00", "#,##0", "dd-mmm-yyyy", "0.0%".
Examples
=TEXT(1234.5, "#,##0.00")
→ 1,234.50
=TEXT(TODAY(), "dd-mmm-yyyy")
→ 09-Sep-2026
=TEXT(A2, "[>=10000000]0.0,,,\"Cr\";[>=100000]0.0,,\"L\";0")
→ Indian Cr/Lakh short form
Good to know
- The result is text — you can't do maths on it. Use number formatting on the cell if you still need the value.
Related functions
More Text functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.