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:

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:

• 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:

 

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