Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .