TEXT
Turns a number into text in a format you choose.
How it’s written
TEXT(value, format)Example
| A | |
|---|---|
| 1 | Amount |
| 2 | 1,250.5 |
=TEXT(A2,"#,##0.00")Result: 1,250.50
Adds the comma and two decimals.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use it when a formatted number needs to sit inside a sentence.
Practice it properly
Replacing and formatting text gives you real tasks, with your formulas tested on data you haven’t seen.