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.
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 | Line | Amount | As text |
| 2 | Installation | 1250.5 | |
| 3 | Annual licence | 899.99 | |
| 4 | Training day | 50 |
Functions used here
What this exercise teachesMay contain 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.