Microsoft Office Tutorials and References
In Depth Information
Excel Has Got Your Number(s)
The number is now embellished by your indigenous currency symbol. If you’re
in the States, you’ll see the dollar sign, in the UK the pound sign, and so on (how
Excel knows what symbol to use is tied to your system setup in Control Panel).
If the number exceeds 999, commas will punctuate where necessary, e.g.,
1,234,582. (In France, the comma is replaced by a space. It’s another
countryspecific, Control Panel thing).
The number will exhibit two decimal points. Thus 27 will appear as 27.00, 678.1
And why the term Accounting ? Well, to repeat—this is a currency-specific format, but of a special
type. What’s special—or at least different—about it is that it lines up the currency symbol independent
of the length of numbers. Consider this example: If I stack these numbers in a column (Figure 4–71):
Figure 4–71. Numbers, pre-formatted
And I click Accounting Number Format, I’ll see (Figure 4–72):
Figure 4–72. Numbers, as per the Accounting format
Note the position of the dollar signs—all positioned in the far left of their cells, even as the actual
numbers describe various widths (note also how the 12 receives those two decimal points, as does
Of course that’s all for starters—and you can stop right there if you’re happy with the defaults. But
if you’re in the US and require a different currency, click the down arrow and some standard,
alternative currency options appear, e.g., the British pound and the Euro.
But if you need something else, click More Accounting Formats (Figure 4–73):