# 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

#### 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.