Related Function:

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

Syntax

=DOLLAR(number,[decimals])

Arguments

Argument Description
number The number to be converted into a text string
[decimals] An optional numerical argument which specifies the number of decimal placesto be shown after the decimal point

 • 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

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

Examples

A B C D
1 Number Formula Result Notes
2 110.24975 =DOLLAR(A2) \$110.24 Default is two decimal places
3   =DOLLAR(A2,0) \$110 Zero decimal places
4   =DOLLAR(A2,1 \$110.2
5   =DOLLAR(A2,2) \$110.24
6   =DOLLAR(A2,3) \$110.249

Usage note: the TEXT function is more flexible than the DOLLAR function

Common Function Error(s)

Problem What went wrong
Result cannot be used in calculations Once a number has been converted, using the DOLLAR function, it is stored in Excel as text and 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 cell formatting into a currency format.