DOLLAR Function in Excel – Convert to currency format in Excel

DOLLAR Function in Excel rounds the supplied number to a specified number of decimal places and converts them into currency format by adding dollar symbol in front.

Syntax of DOLLAR Function in Excel:

DOLLAR(number, [decimals])

Where,

  • number – The number to be converted into currency format
  • [decimal] – An optional argument that specifies the number of decimal places to be rounded off. If omitted, it takes default value as 2 and rounds off to 2 decimal places

 

Example of DOLLAR Function in Excel:

Formula:

DOLLAR Function in Excel 1

  • In first example Dollar function is passed only with numeric value so that it will be rounded off to default 2 decimal places.
  • From second example onwards numeric value is passed along with [decimal] argument which says the number of decimal places to be round off.
  • Dollar Function converts the number into currency format by adding dollar symbol in front

So the result will be

Result:

DOLLAR Function in Excel 2

 

Note: #VALUE! Error occurs if either of the supplied arguments are non-numeric.

previous DOLLAR Function in Excel                                                                                                                next DOLLAR Function in Excel