Excel: Dollar 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:

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"