About currency constants
To format a number as currency, you can use the CY function and pass an optional constant to specify which country/region's currency to use. The currency constants can be specified as the ID number that corresponds to a country/region or as a string (enclosed in quotation marks) that corresponds to an ISO 4217 three-character abbreviation.
If you show currency symbols for nonlocal currencies, and the system does not know the symbol for a given currency, the dollar symbol ($) is displayed.
IDs and abbreviations|
ID |
Abbreviation |
Currency |
|
0 |
SYS |
Uses system settings |
|
1 |
XXX |
Formats as a number |
|
2 - 9 |
Reserved | |
|
10 |
EUR |
Euro |
|
11 |
USD |
U.S. dollar |
|
12 |
ATS |
Austrian schilling |
|
13 |
AUD |
Australian dollar |
|
14 |
BEF |
Belgian franc |
|
15 |
CAD |
Canadian dollar |
|
16 |
CHF |
Swiss franc |
|
17 |
CNY |
Chinese renminbi yuan |
|
18 |
DEM |
German mark |
|
19 |
DKK |
Danish krone |
|
20 |
ESP |
Spanish peseta |
|
21 |
FIM |
Finnish markka |
|
22 |
FRF |
French franc |
|
23 |
GBP |
British pound sterling |
|
24 |
GRD |
Greek drachma |
|
25 |
HKD |
Hong Kong Special Administrative Region (SAR) dollar |
|
26 |
HUF |
Hungarian forint |
|
27 |
IDR |
Indonesian rupiah |
|
28 |
IEP |
Irish punt |
|
29 |
ILS |
Israeli shekel |
|
30 |
ITL |
Italian lira |
|
31 |
JPY |
Japanese yen |
|
32 |
KRW |
Korean won |
|
33 |
LUF |
Luxembourgian franc |
|
34 |
MXN |
Mexican peso (new) |
|
35 |
MYR |
Malaysian ringgit |
|
36 |
NLG |
Dutch guilder |
|
37 |
NOK |
Norwegian krone |
|
38 |
NZD |
New Zealand dollar |
|
39 |
PHP |
Philippine peso |
|
40 |
PLZ |
Polish zloty (As of Visio version 2000, obsolete. Use PLN.) |
|
41 |
PTE |
Portuguese escudo |
|
42 |
ROL |
Romanian leu |
|
43 |
RUR |
Russian ruble (As of Visio version 2000, obsolete. Use RUB.) |
|
44 |
SEK |
Swedish kroner |
|
45 |
SGD |
Singapore dollar |
|
46 |
THB |
Thai baht |
|
47 |
TWD |
Taiwan dollar |
|
48 |
XEU |
European currency unit |
|
49 |
YUN |
Yugoslavian dinar (As of Visio version 2000, obsolete. Use YUM.) |
|
50 |
ZAR |
South African rand |
|
51 - 55 |
Reserved | |
|
56 |
ARS |
Argentinean peso |
|
57 |
BMD |
Bermudian dollar |
|
58 |
BOB |
Bolivian boliviano |
|
59 |
BRR |
Brazilian cruzeiro real (As of Visio version 2000, obsolete. Use BRL.) |
|
60 |
BSD |
Bahamanian dollar |
|
61 |
CLP |
Chilean peso |
|
62 |
COP |
Colombian peso |
|
63 |
CRC |
Costa Rican colon |
|
64 |
CZK |
Czech koruna |
|
65 |
DOP |
Dominican peso |
|
66 |
ECS |
Ecuadorean sucre |
|
67 |
EGP |
Egyptian pound |
|
68 |
HNL |
Honduran lempira |
|
69 |
INR |
Indian rupee |
|
70 |
JMD |
Jamaican dollar |
|
71 |
JOD |
Jordanian dinar |
|
72 |
KWD |
Kuwaiti dinar |
|
73 |
MOP |
Macanese pataca |
|
74 |
NIO |
Nicaraguan cordoba oro |
|
75 |
PAB |
Panamanian balboa |
|
76 |
PEN |
Peruvian nuevo sol |
|
77 |
PKR |
Pakistani rupee |
|
78 |
PYG |
Paraguayan guarani |
|
79 |
SAR |
Saudi riyal |
|
80 |
SIT |
Slovenian tolar |
|
81 |
SKK |
Slovakian koruna |
|
82 |
SVC |
El Salvadoran colon |
|
83 |
TRL |
Turkish lira |
|
84 |
TTD |
Trinidad and Tobago dollar |
|
85 |
UYU |
Uruguayan peso uruguayo |
|
86 |
VEB |
Venezuelan bolivar |
|
87 |
VND |
Vietnamese dong |
|
88 |
BRL |
Brazilian cruzeiro real |
|
89 |
PLN |
Polish zloty |
|
90 |
RUB |
Russian ruble |
|
91 |
YUM |
Yugoslavian dinar |
|
92 |
BYB |
Belarusian ruble |
|
93 |
UAH |
Ukrainian hryvnia |