DOLLAR inside a sentence
Joining a number to text drops its formatting — DOLLAR puts it back.
Task:
The statement email needs one line per customer, such as Balance due: $1,250.50. Build that line in C2:C5 from the balance in B.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of DOLLAR
0/3The same formula in the other shapes it takes at work.
- DOLLAR Function
Turning a number into the text you can drop into a sentence.
CoreIntermediate - DOLLAR inside a sentence
Joining a number to text drops its formatting — DOLLAR puts it back.
Intermediate - TEXT for a percentage in a sentence
The same problem as DOLLAR, for any format: TEXT takes a format code.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Customer | Balance | Email line |
| 2 | Arden Ltd | 1250.5 | |
| 3 | Bexley Co | 89.9 | |
| 4 | Cotton & Rye | 12400 | |
| 5 | Dewhurst | 7.25 |
What this exercise teachesMay contain the answer
Cell formatting lives on the cell, not the value, so the moment a number is joined into text it reverts to its raw form: 89.9 instead of $89.90. Converting it to formatted text first is the only way to keep the currency sign, the separators and the trailing zero.