Microsoft Office Tutorials and References
In Depth Information
Formatting Values: Making the Numbers Look Good
And here we need to issue a reminder. Substituting a $ for a £ in a value does not alter
the numerical value of the data you’ve originally entered. In strictly mathematical terms,
$4,523.00 is equal to £4,523.00; Excel won’t calculate any currency exchange rates or
anything of the sort. The currency symbol is just an embellishment of the number you
wrote (as is the comma and the two decimal points). These are all format changes, and
to repeat the declaration I issued at the outset of the chapter, formatting only changes
the way a number looks.
If you need additional proof, do the following:
Enter 4523 in any cell.
Dress it up in a currency format.
Click back in the cell and direct your attention to the formula bar.
While your cell will display $4,523.00, the formula bar will reveal 4523.
And if you need still more symbols—if you’re trading in Latvian lats or Bulgarian levs or
any of a host of other international currencies, click the More Accounting Formats… option,
shown previously, and you’ll be brought to the dialog shown in Figure 5–60.
Figure 5–60. Scrolling for dollars . . . and other currencies
Scroll that ample list, and select your currency. Then click OK.