### DOLLAR(number [,decimals])

Returns the text string of a number with the dollar formatting \$0,000.00.

 number The number you want formatted. decimals (Optional) The number of digits to the right of the decimal point.

#### Remarks

 * The currency symbol that it applies depends on your language settings. If your language is English (United Kingdon) the symbol used is £.* You can tell that this function returns a text string because the result is left-aligned. Numerical values are right-aligned by default.* The resulting number is rounded when necessary.* The "number" can be a number, a reference to a cell containing a number, or a formula that evaluates to a number.* If "decimals" < 0, then "number" is rounded to the left of the decimal point. * If "decimals" is left blank, then 2 is used.* If "decimal" is empty (i.e. you just include the comma separator), then no decimal places are used. See Example 7.* If "decimals" is not numeric, then #VALUE! is returned.* The major difference between formatting a cell using (Format > Cells) and formatting it with this function is that using this function the result is converted to text. Using (Format > Cells) leaves the number as a number.* If you want to display a value in a currency format and keep it as a number you should apply a Currency Number Format.* Any numbers formatted with this function can still be used in numerical formulas because numbers entered as text are automatically converted to numbers when performing calculations.* You can use the FIXED function to return the text string of a number rounded to a fixed number of decimal places.* You can use the TEXT function to return a text string of a number in any format.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =DOLLAR(100) = \$100.00 2 =DOLLAR(1234.567,2) = \$1,234.57 3 =DOLLAR(1234.567,-2) = \$1,200.00 4 =DOLLAR(-1234.567,2) = -\$1,234.57 5 =DOLLAR(-1234.567,-2) = -\$1,200.00 6 =DOLLAR(1234.567,0) = \$1,235.00 7 =DOLLAR(1234.567,) = \$1,235.00 8 =DOLLAR(-0.123,4) = -\$0.12 9 =DOLLAR(99.888) = \$99.89 10 =DOLLAR(99.888,) = \$100.00 11 =DOLLAR("some text") = #VALUE!

 1 - What is the default currency formatting for the value 100.2 - What is the currency format for the value 1234.567 with 2 digits to the right of the decimal point.3 - What is the currency format for the value 1234.567 when rounded to 2 digits to the left of the decimal point.4 - What is the currency format for the value -1234.567 with 2 digits to the right of the decimal point.5 - What is the currency format for the value -1234.567 when rounded to 2 digits to the left of the decimal point.6 - What is the currency format for the value 1234.567 when rounded to 0 digits to the right of the decimal point.