DOLLAR
Converts a number to text using the local currency format, with rounding to a specified number of decimal places. The result is text, not a number.
DOLLAR(number, [decimals])Arguments
numberThe number to format as currency.decimalsThe number of decimal places (default 2). Negative values round to the left of the decimal point.(optional)
=DOLLAR(1234.567)Formats with 2 decimals and the local currency symbol
=DOLLAR(1234.567,0)Rounds to 0 decimal places
=DOLLAR(-1234.567,2)Negative values are shown in parentheses in US format
- •DOLLAR returns text — you cannot do math on the result
- •Uses the system's local currency symbol (€, £, ¥, etc.) depending on regional settings
- •Use TEXT for full control over the format string
- •For numeric formatting that keeps the value as a number, use a cell number format instead
- •Confusing DOLLAR's output with a genuine number - it returns formatted text, so the result can't be used directly in further arithmetic without converting it back with VALUE
- •Forgetting that DOLLAR always uses the currency symbol tied to the system's regional settings, not necessarily a literal dollar sign, despite its English name
- •Not specifying the optional decimals argument when a different number of decimal places is needed, leaving DOLLAR to default to two, which may not match the desired format
TEXTOffers more flexible, customizable formatting than DOLLAR, including full control over currency symbols, thousands separators, and negative number display.FIXEDFormats a number with a fixed number of decimals like DOLLAR, but without adding a currency symbol.VALUEConverts DOLLAR's text output back into a genuine number if further calculation is needed.Can I use DOLLAR's result in a calculation?
Not directly - DOLLAR returns text, not a number. Wrap it in VALUE first if you need to use the result in further arithmetic.
Does DOLLAR always show a dollar sign?
Not necessarily - it uses whatever currency symbol matches your system's regional settings, so it might show €, £, or another symbol depending on your locale.
How do I control the number of decimal places DOLLAR shows?
Use the second, optional argument, like DOLLAR(1234.5,0), which rounds to zero decimal places instead of the default two.
Need to translate a formula using DOLLAR?
Use our translator to convert your complete formula