DOLLAR(number [,decimals])

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

numberThe 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.office.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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top