Microsoft® Excel® 2010 Formulas & Functions Inside Out

DOLLAR()

Syntax. DOLLAR(number,decimals)

Definition. This function converts numbers into text and uses the currency format. The name of the function and the assigned currency symbol depend on the country settings. The decimal places are rounded according to the decimal places specified for the conversion. The default format is $#,##0.00;–$#,##0.00.

Arguments

• number (required). A numeric value, a reference to a cell that contains a number, or a formula that returns a number

• decimals (optional). The number of digits after the decimal point

  • If the decimal places are negative, the number of digits to the left of the decimal point are rounded.

  • If no decimal places are indicated, two decimal places are used.

Background. The difference between the Format/Cells ...