Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

# Excel DOLLAR Function

While using Excel worksheet, the excel DOLLAR function is used to transform any number to text employing Currency number format. The same result can be also achieved through TEXT function.

## Formula

The formula for excel DOLLAR function is given below:

`=DOLLAR(number, decimals)`

## Explanation

A number represents any number which we want to convert. Whereas, decimals shows the total number of digits present on the right side of the decimal point. Its DEFAULT value is 2.

## Example:

B4:B8 range contains a number we want to convert into currency format using DOLLAR function. Then the formula is inserted in cells C4:C6 to get results (See screenshot).

Figure 1 Example of Excel Dollar Function

## Notes

• 2 is the default value for decimals. In cases when number have negative decimal places then rounding will take place on the left side of decimal point.
• The function name and currency symbol employed is conditional to a language used by the computer.