Introduction
DOLLAR in excel is a text/string function. This function converts a numeric value into text value using Currency Format and it also rounds off decimal places to the value specified. The currency character used is dependent on the local languages settings. Format which this function uses is$#,##0.00_);($#,##0.00). For example, 12 is converted to $12 by using the formula =DOLLAR(12)
Syntax
=DOLLAR(Number, Decimals)
Arguments
- Number: It is the number or a reference to a cell which contains the number.
- Decimals: It is number of decimal places to right of decimal point. By default its value is 2. If negative value is entered than it rounds off to the left of decimal point.
Keynotes
- Format which this function uses is$#,##0.00_);($#,##0.00).
- By default its value is 2. If negative value is entered than it rounds off to the left of decimal point.
- The currency character used is dependent on the local languages settings.
- TEXT function can also be used on place of DOLLAR function and also provides many other options too, TEXT function is more flexible.
Examples
In this example, Some numeric values are given in column A and they are converted to text using DOLLAR function with currency formatting.
| Formula |
| =DOLLAR(A4) |
| =DOLLAR(A5) |
| =DOLLAR(A6,1) |
| =DOLLAR(A7,0) |
| Number | Text |
| 49 | $49.00 |
| 51 | $51.00 |
| 53.25 | $53.3 |
| 99.99 | $100 |
