Exercises / Cleaning text · 11 of 13
A label with a formatted number
Joining a number to text drops its formatting: "Total: "&B8 shows 18342.5. TEXT(value, format) turns a number into formatted text first, like TEXT(0.256,"0.0%") for 25.6%.
Your taskIn D2, build the label "Total: " followed by the total in B8, formatted with TEXT as dollars with a thousands separator and 2 decimals ($#,##0.00).
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Month | Revenue | Label | |
| 2 | Jan | $2,840.50 | ||
| 3 | Feb | $3,102.00 | ||
| 4 | Mar | $2,975.25 | ||
| 5 | Apr | $3,360.00 | ||
| 6 | May | $2,880.75 | ||
| 7 | Jun | $3,184.00 | ||
| 8 | Total | $18,342.50 |