Microsoft Office Tutorials and References
In Depth Information
Changing Text
Figure 16-4:
Using
DOLLAR to
round
numbers
and format
them as
currency.
Example
Result
$1,234.56
=DOLLAR(1234.56,2)
=DOLLAR(1234.56,1)
$1,234.6
=DOLLAR(1234.56,0)
$1,235
=DOLLAR(1234.56,-1)
$1,230
=DOLLAR(1234.56,-2)
$1,200
=DOLLAR(1234.56,-3)
$1,000
Using DOLLAR is easy:
1. Position the cursor in the cell where you want the results to appear.
2. Enter =DOLLAR( to begin the function entry.
3. Click a cell that contains a number, or enter a number.
4. Enter a comma ( ,).
5. Enter a number to indicate the number of decimal points to display.
If the number is 0, then no decimal points are displayed. Numbers less
than 0 force rounding to occur to the left of the decimal point.
6. Type a ), and press Enter.
Search JabSto ::




Custom Search