Excel functions / Text
DOLLAR function
A number as text in currency style: $1,234.57, with negatives in brackets.
Syntax
=DOLLAR(number, [decimals])
Arguments
number: The number.decimals(optional): Decimal places (default 2). Negative rounds to tens, hundreds…
When to use it
DOLLAR turns a number into text in currency format, rounded to the decimals you choose. It is a shortcut for TEXT with a currency format, for building sentences that mention an amount.
Examples
An amount in a sentence
A B C 1 Total 2 1234.5 Total due: $1,234.50 In C2:
="Total due: " & DOLLAR(A2)→ Total due: $1,234.50Rounded to whole dollars
A B C 1 Total 2 1234.5 $1,235 In C2:
=DOLLAR(A2, 0)→ $1,235
Common mistakes
- The result is text. DOLLAR gives text, which cannot be added up. To show a number as money and keep it a number, use a currency number format instead.
DOLLAR in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: KČ
- Danish: KR
- Dutch: EURO
- Finnish: VALUUTTA
- French: DEVISE
- German: DM
- Hungarian: FORINT
- Italian: VALUTA
- Norwegian: VALUTA
- Polish: KWOTA
- Portuguese (Brazil): MOEDA
- Portuguese (Portugal): MOEDA
- Russian: РУБЛЬ
- Spanish: MONEDA
- Swedish: VALUTA
- Turkish: LİRA