DOLLAR

DOLLAR

Sponsored Link

Purpose 

Convert a number to text in currency format

Return value 

A number as text in currency format.

Syntax 

=DOLLAR (number, decimals)

Arguments 

  • number – The number to convert.
  • decimals – The number of digits to the right of the decimal point. Default is 2.

Usage notes 

The DOLLAR function converts a number to text using currency number format. The number format used is $#,##0.00_);($#,##0.00).

The default for decimals is 2. If decimals is negative, number will be rounded to the left of the decimal point.

The TEXT function is a more flexible way to achieve the same result, since it can convert numbers to text in currency format and other number formats as well.

The name of the function and the currency symbol used is based on language settings of the computer.

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo