Excel practice · Text Functions

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

  1. Format a number as currency text
  2. Format a decimal as a percentage
  3. Build a report line with a formatted number inside it

The exercises

1. Format a number as currency text Easy

Format 1500 as currency text, with a thousands separator and two decimal places, for a report that needs the number displayed as text.

AB
1Amount1500
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.

2. Format a decimal as a percentage Easy

Format the decimal 0.256 as a percentage with one decimal place.

AB
1Rate (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.

3. Build a report line with a formatted number inside it Medium

Build a single line like "Total: $1,234.50" by combining a label with a formatted number.

AB
1Total1234.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 →

More text functions practice

All Excel practice exercises · Excel test prep