Text Functions
Intermediate
DOLLAR Function
Turning a number into the text you can drop into a sentence.
Task:
You are pasting these figures into a quote you are about to email, and inside the sentence they need to read as currency rather than as bare numbers. Put each amount as formatted text in column C.
Learning Objectives:
- Format a number as currency text with DOLLAR
- Control the number of decimal places
- Know when a value has stopped being a number
Hints
Solve without hints for +5 XP
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 | Line | Amount | As text |
| 2 | Installation | 1250.5 | |
| 3 | Annual licence | 899.99 | |
| 4 | Training day | 50 |
What this exercise teaches (contains the answer)
DOLLAR exists for the moment a number has to sit inside a sentence: ="Your total is "&DOLLAR(B2,2) reads properly, where joining the raw number gives you "Your total is 1250.5". The trade is that the result has stopped being a number and will no longer add up, so you format at the end of a calculation and never in the middle of one.