Wednesday, February 9, 2011

Dollar Excel Function

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"
Stumble This Fav This With Technorati Add To Digg This Add To Reddit Add To Facebook Add To Yahoo


Post a Comment

Related Posts Plugin for WordPress, Blogger...


Twitter Delicious Facebook Digg Stumbleupon Favorites