Quick, clean, and to the point

Excel DOLLAR Function

Excel DOLLAR function

The Excel DOLLAR function converts a number to text using the Currency number format. The TEXT function can do the same thing, and is much more versatile.

Convert a number to text in currency format
Return value 
A number as text in currency format.
=DOLLAR (number, decimals)
  • number - The number to convert.
  • decimals - The number of digits to the right of the decimal point. Default is 2.
Usage notes 
  • The DOLLAR function converts a number to text using currency number format: $#,##0.00_);($#,##0.00).
  • The default for decimals is 2. If decimals is negative, number will be rounded to the left of the decimal point.
  • The name of the function and the currency symbol used is based on language settings of the computer.
  • The TEXT function is a more flexible way to achieve the same result.