← Back to level 1
Level 1Level 1
TEXT
Formats values as text with a custom appearance.
Syntax
=TEXT(value, format_text)Step-by-step explanation
- 1Use it when you want numbers or dates to display in a specific style.
- 2Pick a format string that matches the output you need.
- 3Great for labels, reports, and readable summaries.
Common mistakes
Using the wrong format string
Thinking TEXT changes the underlying number
Combining it too early in calculations
Example table
A quick scenario to connect the syntax to the result.
| 4500 | 12/05/2026 |
Formula
=TEXT(A1,"$#,##0")
Result
$4,500
Practice area
Format a value as currency.
Match against the syntax block above.