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 Yuan Renminbi |
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 |
35 |
MYR |
Malaysian Ringgit |
36 |
NLG |
Dutch Guilder |
37 |
NOK |
Norwegian Krone |
38 |
NZD |
New Zealand Dollar |
39 |
PHP |
Philippine Peso |
40 |
PLZ (Historic. Use PLN.) |
Polish Zloty |
41 |
PTE |
Portuguese Escudo |
42 |
ROL |
Romanian Leu |
43 |
RUR (Historic. Use RUB.) |
Russian Ruble |
44 |
SEK |
Swedish Kroner |
45 |
SGD |
Singapore Dollar |
46 |
THB |
Thai Baht |
47 |
TWD |
New Taiwan Dollar |
48 |
XEU (Historic. Use EUR.) |
ECU (pre-1998) |
49 |
YUN (Historic. Use YUM.) |
Yugoslavian Dinar |
50 |
ZAR |
South African Rand |
51 - 55 |
Reserved |
|
56 |
ARS |
Argentinean Peso |
57 |
BMD |
Bermudian Dollar |
58 |
BOB |
Bolivian Boliviano |
59 |
BRR (Historic. Use BRL.) |
Brazilian Cruzeiro Real |
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 |
TRY |
New 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 (Historic. Use BYR.) |
Belarusian Ruble |
93 |
UAH |
Ukrainian Hryvnia |
94 |
AFA |
Afghani (added in Visio 2002) |
95 |
ALL |
Lek (added in Visio 2002) |
96 |
DZD |
Algerian Dinar (added in Visio 2002) |
97 |
ADP |
Andorran Peseta (added in Visio 2002) |
98 |
AOA |
Kwanza (added in Visio 2002) |
99 |
XCD |
East Caribbean Dollar (added in Visio 2002) |
100 |
AMD |
Armenian Dram (added in Visio 2002) |
101 |
AWG |
Aruban Guilder (added in Visio 2002) |
102 |
AZM |
Azerbaijanian Manat (added in Visio 2002) |
103 |
BHD |
Bahraini Dinar (added in Visio 2002) |
104 |
BDT |
Taka (added in Visio 2002) |
105 |
BBD |
Barbados Dollar (added in Visio 2002) |
106 |
BYR |
Belarussian Ruble (added in Visio 2002) |
107 |
BZD |
Belize Dollar (added in Visio 2002) |
108 |
XOF |
CFA Franc BCEAO (added in Visio 2002) |
109 |
BTN |
Ngultrum (added in Visio 2002) |
110 |
BAM |
Convertible Marks (added in Visio 2002) |
111 |
BWP |
Pula (added in Visio 2002) |
112 |
BND |
Brunei Dollar (added in Visio 2002) |
113 |
BGL (Historic. Use BGN.) |
Lev |
114 |
BGN |
Bulgarian Lev (added in Visio 2002) |
115 |
BIF |
Burundi Franc (added in Visio 2002) |
116 |
KHR |
Riel (added in Visio 2002) |
117 |
XAF |
CFA Franc BEAC (added in Visio 2002) |
118 |
CVE |
Cape Verde Escudo (added in Visio 2002) |
119 |
KYD |
Cayman Islands Dollar (added in Visio 2002) |
120 |
KMF |
Comoro Franc (added in Visio 2002) |
121 |
CDF |
Franc Congolais (added in Visio 2002) |
122 |
HRK |
Croatian Kuna (added in Visio 2002) |
123 |
CUP |
Cuban Peso (added in Visio 2002) |
124 |
CYP |
Cyprus Pound (added in Visio 2002) |
125 |
DJF |
Djibouti Franc (added in Visio 2002) |
126 |
TPE |
Timor Escudo (added in Visio 2002) |
127 |
ERN |
Nakfa (added in Visio 2002) |
128 |
EEK |
Kroon (added in Visio 2002) |
129 |
ETB |
Ethiopian Birr (added in Visio 2002) |
130 |
FKP |
Falkland Islands (Islas Malvinas) Pound (added in Visio 2002) |
131 |
FJD |
Fijian Dollar (added in Visio 2002) |
132 |
XPF |
CFP Franc (added in Visio 2002) |
133 |
GMD |
Dalasi (added in Visio 2002) |
134 |
GEL |
Lari (added in Visio 2002) |
135 |
GHC |
Cedi (added in Visio 2002) |
136 |
GIP |
Gibraltar Pound (added in Visio 2002) |
137 |
GTQ |
Quetzal (added in Visio 2002) |
138 |
GNF |
Guinea Franc (added in Visio 2002) |
139 |
GWP |
Guinea-Bissau Peso (added in Visio 2002) |
140 |
GYD |
Guyana Dollar (added in Visio 2002) |
141 |
HTG |
Gourde (added in Visio 2002) |
142 |
ISK |
Iceland Krona (added in Visio 2002) |
143 |
IRR |
Iranian Rial (added in Visio 2002) |
144 |
IQD |
Iraqi Dinar (added in Visio 2002) |
145 |
KZT |
Tenge (added in Visio 2002) |
146 |
KES |
Kenyan Shilling (added in Visio 2002) |
147 |
KPW |
North Korean Won (added in Visio 2002) |
148 |
KGS |
Som (added in Visio 2002) |
149 |
LAK |
Kip (added in Visio 2002) |
150 |
LVL |
Latvian Lats (added in Visio 2002) |
151 |
LBP |
Lebanese Pound (added in Visio 2002) |
152 |
LSL |
Loti (added in Visio 2002) |
153 |
LRD |
Liberian Dollar (added in Visio 2002) |
154 |
LYD |
Libyan Dinar (added in Visio 2002) |
155 |
LTL |
Lithuanian Litus (added in Visio 2002) |
156 |
MKD |
Denar (added in Visio 2002) |
157 |
MGF |
Malagasy Franc (added in Visio 2002) |
158 |
MWK |
Malawian Kwacha (added in Visio 2002) |
159 |
MVR |
Rufiyaa (added in Visio 2002) |
160 |
MTL |
Maltese Lira (added in Visio 2002) |
161 |
MRO |
Ouguiya (added in Visio 2002) |
162 |
MUR |
Mauritius Rupee (added in Visio 2002) |
163 |
MDL |
Moldovan Leu (added in Visio 2002) |
164 |
MNT |
Tugrik (added in Visio 2002) |
165 |
MAD |
Moroccan Dirham (added in Visio 2002) |
166 |
MZM |
Metical (added in Visio 2002) |
167 |
MMK |
Kyat (added in Visio 2002) |
168 |
NAD |
Namibia Dollar (added in Visio 2002) |
169 |
NPR |
Nepalese Rupee (added in Visio 2002) |
170 |
ANG |
Netherlands Antillian Guilder (added in Visio 2002) |
171 |
NGN |
Naira (added in Visio 2002) |
172 |
OMR |
Rial Omani (added in Visio 2002) |
173 |
PGK |
Kina (added in Visio 2002) |
174 |
QAR |
Qatari Rial (added in Visio 2002) |
175 |
RWF |
Rwanda Franc (added in Visio 2002) |
176 |
SHP |
Saint Helena Pound (added in Visio 2002) |
177 |
WST |
Tala (added in Visio 2002) |
178 |
STD |
Dobra (added in Visio 2002) |
179 |
SCR |
Seychelles Rupee (added in Visio 2002) |
180 |
SLL |
Leone (added in Visio 2002) |
181 |
SBD |
Solomon Islands Dollar (added in Visio 2002) |
182 |
SOS |
Somali Shilling (added in Visio 2002) |
183 |
LKR |
Sri Lanka Rupee (added in Visio 2002) |
184 |
SDD |
Sudanese Dinar (added in Visio 2002) |
185 |
SRG |
Suriname Guilder (added in Visio 2002) |
186 |
SZL |
Lilangeni (added in Visio 2002) |
187 |
SYP |
Syrian Pound (added in Visio 2002) |
188 |
TJR (Historic. Use TJS.) |
Tajik Ruble |
189 |
TJS |
Tajik Somoni (added in Visio 2002) |
190 |
TZS |
Tanzanian Shilling (added in Visio 2002) |
191 |
TOP |
Pa'anga (added in Visio 2002) |
192 |
TND |
Tunisian Dinar (added in Visio 2002) |
193 |
TMM |
Manat (added in Visio 2002) |
194 |
UGX |
Uganda Shilling (added in Visio 2002) |
195 |
AED |
UAE Dirham (added in Visio 2002) |
196 |
UZS |
Uzbekistan Sum (added in Visio 2002) |
197 |
VUV |
Vatu (added in Visio 2002) |
198 |
YER |
Yemeni Rial (added in Visio 2002) |
199 |
ZMK |
Zambian Kwacha (added in Visio 2002) |
200 |
ZWD |
Zimbabwe Dollar (added in Visio 2002) |