Page 125 - Excel Timesaving Techniques for Dummies

23_574272 ch20.qxd 10/1/04 10:43 PM Page 110
110
Technique 20: Customizing Number Formats
TABLE 20-2: EURO CONVERSION ISO CODES
ISO Code Country/Region Unit of Currency
ATS Austria Schilling
BEF Belgium Franc
EUR Euro member state Euro
FIM Finland Markka
• Figure 20-9: Use the EuroValue toolbar to convert euro FRF France Franc
currency to and from a member’s pre-euro
DEM Germany Deutsche mark
currency.
GRD Greece Drachma
The conversion options on this drop-down list make IEP Ireland Pound
extensive use of the three-letter ISO codes that refer
ITL Italy Lira
to particular countries and their former currencies
within the union. (Refer to Table 20-2 to decode LUF Luxembourg Franc
these abbreviations.)
NLG Netherlands Guilder
In addition to the EuroValue toolbar, the Euro PTE Portugal Escudo
Currency Tools add-in attaches a Euro Conversion
ESP Spain Peseta
command to the Tools pull-down menu. Selecting
this command opens a Euro Conversion dialog box
that also enables you to convert from one euro mem-
ber currency to another.