Excel TEXT number formatting practice exercises
3 graded problems with realistic data, from easy to medium.
Turns a number into formatted text using a format code: the way to bake $, %, or padded zeros right into a displayed value. The 3 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the TEXT number formatting guide first: syntax, a worked example and the mistakes people make.
In this set
- Format a number as currency text
- Format a decimal as a percentage
- Build a report line with a formatted number inside it
The exercises
Format 1500 as currency text, with a thousands separator and two decimal places, for a report that needs the number displayed as text.
| A | B | |
|---|---|---|
| 1 | Amount | 1500 |
| 2 | ? |
Enter a formula in A2.
Show a hint
TEXT(value, format_text) turns a number into exactly-formatted text: =TEXT(B1,"$#,##0.00").
TEXT is how a number gets to look a specific way inside a sentence or a label built with CONCATENATE; the cell's own number format never applies once it's glued into a text string.
Format the decimal 0.256 as a percentage with one decimal place.
| A | B | |
|---|---|---|
| 1 | Rate (decimal) | 0.256 |
| 2 | ? |
Enter a formula in A2.
Show a hint
TEXT(value, "0.0%") multiplies by 100, rounds to one decimal, and adds the % sign: =TEXT(B1,"0.0%").
This is exactly what a percentage cell format does visually; TEXT does the same thing but produces an actual text string you can combine with other text.
Build a single line like "Total: $1,234.50" by combining a label with a formatted number.
| A | B | |
|---|---|---|
| 1 | Total | 1234.5 |
| 2 | ? |
Enter a formula in A2.
Show a hint
Combine CONCATENATE with TEXT: =CONCATENATE("Total: ",TEXT(B1,"$#,##0.00")). Without TEXT, the raw number would show as plain "1234.5" with no formatting at all.
This is the single most common real use of TEXT: building a dashboard label, an email merge line, or a dynamic chart title where a number has to sit inside a sentence, formatted properly.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the TEXT number formatting exercises →