The Excel DOLLAR Function

Home » Excel-Built-In-Functions » Excel-Dollar-Function

Search this site:

Custom Search

Related Functions :

TEXT Function

Basic Description

The Excel DOLLAR function rounds a supplied number to a specified number of decimal places and then converts this into text, using a currency format.

The format of the function is :

DOLLAR( Number, [Decimals] )

Where the arguments are as follows :

Number

The number to be converted into a text string

[Decimals]

An optional numerical argument which specifies the number of decimal places to be shown 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
-	If Decimals is a decimal (rather than an integer), it is truncated to an integer

Note that the Excel Dollar function uses the currency that is set as the default on your computer. The examples below use UK pounds sterling (£).

Example

The spreadsheet below shows examples of use of the Excel Dollar Function. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the results.

Formulas
Examples of use of the Excel Dollar Function

Results

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.

If you want to be able to use the numbers in calculations, you may prefer to keep the values as numbers in Excel and just change the formatting into a currency format. To do this:

Right click with the mouse, on the cell to be formatted
Select the Format Cells ... option and ensure the Number tab is selected
Under the Category heading, select the option Currency
From the options that appear on the right, specify the details of the formatting required
Click OK