Microsoft Office Tutorials and References
In Depth Information
Understanding How Excel Handles Money
including the ability to control the placement of commas and decimals, and
even how to format negative values.
People are used to seeing money amounts formatted with a currency symbol
and a certain number of decimal places. In the United States and Canada, that
is the dollar sign and two decimal places. Let’s face it — $199.95 looks like
money, but 199.950 does not. Excel makes formatting cells to display money
amounts as easy as clicking a button. To format amounts as dollars, follow
these steps:
1. Select the cell or cells you want to format.
2. Click the Dollar ($) button on the Ribbon’s Home tab, in the Number
This technique assigns Excel’s default Accounting format to the selected
cells. In the United States, the default currency format follows:
A dollar sign, aligned to the left of the cell
Two decimal places
Negative numbers enclosed in parentheses
The default format depends on your locale, which is a setting of the
operating system. If you’re in Italy, for example, the locale should be set so that the
default currency format is the euro (€).
But suppose you don’t want the default currency formatting. Perhaps you’re
in the United States and working on a spreadsheet for the London office. You
can specify the currency symbol, the number of decimal places, and how
negative values are shown by following these steps:
1. Select the cell or cells you want to format.
2. Right-click the cell(s) and choose Format Cells from the drop-down
Figure 5-1.
4. Click Currency in the Category list.
5. Select the desired number of decimal places from the Decimal Places
spinner control.
6. Select the desired currency symbol from the Symbol drop-down list.
7. Select the desired format for negative numbers from the Negative
Numbers list.
8. Click OK to apply the formatting.
Search JabSto ::

Custom Search