← Back to level 1
Level 1Next
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
Worked example
- 1Inspect the source text in the sample table and decide what should change.
- 2Enter =TEXT(A1,"$#,##0") to format, join, or extract the text.
- 3The final text result should read $4,500.
Practice area
Format a value as currency.
Match against the syntax block above.