Related Function:

The DOLLAR function rounds a supplied number to a specified number of decimal places and then converts this into text, using a currency format. 




Argument Description
number The number to be converted into a text string
[decimals] An optional numerical argument which specifies the number of decimal placesto be shown after the decimal point

  if [decimals] is omitted, it takes on the default value of 2
  if [decimals] is negative, the supplied number is rounded up to the left of the decimal point

Note: The currency format used is the format that is set as the default on your computer.


  A B C D
1 Number Formula Result Notes
2 110.24975 =DOLLAR(A2) $110.24 Default is two decimal places
3   =DOLLAR(A2,0) $110 Zero decimal places
4   =DOLLAR(A2,1 $110.2  
5   =DOLLAR(A2,2) $110.24  
6   =DOLLAR(A2,3) $110.249  

Usage note: the TEXT function is more flexible than the DOLLAR function

Common Function Error(s)

Problem What went wrong
Result cannot be used in calculations Once a number has been converted, using the DOLLAR function, it is stored in Excel as text and cannot be used in numeric calculations

If you want to be able to use the numbers in calculations, you may prefer to keep the values as numbers in Excel and just change the cell formatting into a currency format.