Excel DOLLAR Function

Using the Excel DOLLAR Function


The DOLLAR function will convert a number into text in a currency format. The decimals will be rounded to a user specified number of places. The currency symbol used will depend on your computer's local settings.


=DOLLAR (number, [decimals])

Syntax Breakdown

Required. A number, a formula that evaluates to a number, or a reference to a cell that contains a number.

Optional. The number of digits to the right of the decimal place. The default number of decimal places is 2. This argument can be negative and the function then rounds to the left of the decimal point.

Usage Notes

DOLLAR converts a number to text using the Currency formatting.

Possible Issues With DOLLAR
The DOLLAR function returns the input number as text. This may cause problems when used with other functions, such as SUM, AVERAGE, MIN, etc., that ignore numbers stored as text.

To avoid this issue, enter Ctrl + 1 to access the Format Cells dialog box and select Currency. Alternatively, you can navigate to Home > Number and apply the currency formatting.