Dollar Excel Function
In Excel, the Dollar function converts a number to text, using a currency format. The format used is $#,##0.00_);($#,##0.00).
The syntax for the Dollar function is:
Dollar( number, decimal places )
number is the number to convert to text.
decimal_places is the number of decimal places to display. The number will be rounded accordingly.
Applies To:
Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
A1 = 120.1
A2 = 52
Based on the Excel spreadsheet above:
=Dollar(A1, 0) would return "$120"
=Dollar(A1, 2) would return "$120.10"
=Dollar(A2, 1) would return "$52.1"
=Dollar(1345, 2) would return "$1,345.00"
=Dollar(A1+A2, 2) would return "$172.10"
The syntax for the Dollar function is:
Dollar( number, decimal places )
number is the number to convert to text.
decimal_places is the number of decimal places to display. The number will be rounded accordingly.
Applies To:
Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
A1 = 120.1
A2 = 52
Based on the Excel spreadsheet above:
=Dollar(A1, 0) would return "$120"
=Dollar(A1, 2) would return "$120.10"
=Dollar(A2, 1) would return "$52.1"
=Dollar(1345, 2) would return "$1,345.00"
=Dollar(A1+A2, 2) would return "$172.10"
0 comments:
Post a Comment