DOLLAR function
DOLLAR turns a number into text formatted as currency, using your system's currency symbol. The result is text, so it cannot be summed; format the cells instead if you still need math.
Example
Read it as a sentence: turn 1234.567 into text formatted as dollars with 2 decimal places, which gives $1,234.57.
A
B
C
D
1
$1,234.57
2
3
Syntax
DOLLAR(number, [decimals])
Arguments in [square brackets] are optional.
-
number(required) - The number to format.
-
decimals(optional) - Digits after the decimal point; default 2. Negative values round to the left of the point.
Returns: Text showing the number as currency.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=DOLLAR(1234.567) | $1,234.57 | Default 2 decimals |
=DOLLAR(1234.567,0) | $1,235 | 0 decimals |
=DOLLAR(1234.567,-2) | $1,200 | Round left of the point |
=DOLLAR(-5) | ($5.00) | Negative |
=DOLLAR("12") | $12.00 | Text number |
=DOLLAR("a") | #VALUE! | Bad text |
=DOLLAR(1,128) | #VALUE! | Decimals past 127 |
Watch out for
- Result is text, not a number.
- The symbol follows your regional settings, not necessarily dollars.
Where it works
- Excel
- DOLLAR is in every version of Excel from 2007 on.
- Google Sheets
- No direct equivalent. Use TEXT(number,"$#,##0.00") instead.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .