The Excel DOLLAR Function

Related Functions:
FIXED Function
TEXT Function

Basic Description

The Excel Dollar function rounds a supplied number to a specified number of decimal places and then converts this into a text string with a currency format.

The currency format used is the format that is set as the default on your computer.

The syntax of the Excel Dollar function is:

DOLLAR( number, [decimals] )

Where the function arguments are as follows:

number-The number to be converted into a text string.
[decimals]-

An optional numeric argument that specifies the number of decimal places to be displayed after the decimal point.

Note:

  • If [decimals] is omitted, it takes on the default value of 2;
  • If [decimals] is negative, the supplied number is rounded up to the left of the decimal point.


Dollar Function Examples

The following spreadsheet shows the Excel Dollar Function, used to convert the number 123.591 to a text representation of a currency, rounded to different numbers of decimal places.

 Formulas:
 A
1=DOLLAR( 123.591 )
2=DOLLAR( 123.591, 1 )
3=DOLLAR( 123.591, 0 )
4=DOLLAR( 123.591, -1 )
5=DOLLAR( 123.591, -2 )
 Results:
 A
1$123.59
2$123.6
3$124
4$120
5$100

Note that, in cell A1 of the above spreadsheet, the [decimals] argument is omitted from the Dollar function, so the default value of 2 is used.


For further examples of the Excel Dollar function, see the Microsoft Office website.


Dollar Function Error

If you get an error from the Excel Dollar Function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs either of the supplied arguments are non-numeric.


Dollar Function Common Problem

Some users encounter the following problem when using the Excel Dollar function:

Common Problem:

Once a number has been converted, using the Excel Dollar function, it is stored in Excel as text. Therefore, it cannot be used in numeric calculations.

Solution:

If you want to be able to use your currency values in calculations, you should not use the Excel Dollar function. Instead, you should simply change the formatting of the original number into a currency format.

The easiest way to do this is to select the Currency formatting button on the Excel ribbon. This is generally located in the 'Number' group, on the Home tab of the ribbon (see below):

Format Currency Button on Excel Ribbon

For further details of Excel Formatting, see the Excel formatting page.