|
|
DOLLAR
Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00).
Syntax
DOLLAR(number,decimals)
Number is a number, a reference to a cell containing a number, or a formula that evaluates to a number.
Decimals is the number of digits to the right of the decimal point. If decimals is negative, number is rounded to the left of the decimal point. If you omit decimals, it is assumed to be 2.
Remark
The major difference between formatting a cell that contains a number with the Currency format (Format tab, Commands and Options dialog box) and formatting a number directly with the DOLLAR function is that DOLLAR converts its result to text. A number formatted with the Currency format is still a number. You can continue to use numbers formatted with DOLLAR in formulas, because numbers entered as text values are converted to numbers when calculated.
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
How?
- Create a blank spreadsheet.
- Select the example in the Help topic.
Selecting an example from Help
- Press CTRL+C.
- In the spreadsheet, select cell A1, and press CTRL+V.
- To switch between viewing the formula that returns the result and the result in the cell, select the cell and press F2 and then ENTER, or click Commands and Options on the spreadsheet toolbar, click the Formula tab, and look in the Formula in active cell (active cell) box.
| Data | |
|---|---|
| 1234.567 | |
| -1234.567 | |
| -0.123 | |
| 99.888 | |
| Formula | Description (Result) |
| =DOLLAR(A2, 2) | Displays the first number in a currency format, 2 digits to the right of the decimal point ($1,234.57) |
| =DOLLAR(A2, -2) | Displays the first number in a currency format, 2 digits to the left of the decimal point ($1,200) |
| =DOLLAR(A3, -2) | Displays the second number in a currency format, 2 digits to the left of the decimal point (($1,200)) |
| =DOLLAR(A4, 4) | Displays the third number in a currency format, 4 digits to the right of the decimal point(($0.1230)) |
| =DOLLAR(A5) | Displays the fourth number in a currency format, 2 digit to the left of the decimal point ($99.89) |