Syntax
DOLLAR(number, [decimals])
| Parameter | Description |
|---|---|
| number | Parameter of the DOLLAR function. |
| [decimals] | (Optional.) Parameter of the DOLLAR function. |
Examples
Format as currency
Formula
=DOLLAR(1234.5, 2)
Returns "$1,234.50" — formatted with dollar sign, comma, and two decimal places as a text string.
Whole dollar amount
Formula
=DOLLAR(99999, 0)
Returns "$99,999" — no decimal places, clean dollar format.
In a sentence
Formula
="Your total is " & DOLLAR(A1, 2)
If A1=87.5, returns "Your total is $87.50". Perfect for building invoice summaries in formulas.
Common Errors
#VALUE!
Occurs when the first argument is non-numeric text or when decimals is not a valid number.
Tips
Returns text, not a number
Like FIXED, DOLLAR returns a text string. You cannot do arithmetic with the result. Use it only for display.
Locale-dependent
DOLLAR uses your system's locale currency symbol. In some regions it may show £, €, or ¥ instead of $. For explicit control, use ="$" & FIXED(A1, 2).
Negative values
Negative numbers are shown in parentheses or with a minus sign depending on locale: =DOLLAR(-500, 2) might return "($500.00)".
Try DOLLAR in Viztab
Import your data and use DOLLAR with 370+ other formulas. No signup required.
Open Viztab