DOLLAR

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
* For the Google documentation refer to support.google.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.