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 Cruziero 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 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 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 (Historic. Use EUR.) |
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 (Historic. Use MGA.) |
Madagascar 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) |
| 201 |
VEF |
Venezuelan Bolivar Fuente (added in Visio 2010) |
| 202 |
MGA |
Malagasy Ariary (added in Visio 2010) |
| 203 |
RSD |
Serbian Dinar (added in Visio 2010) |
| 204 |
CSD (Historic. Use RSD.) |
Serbian Dinar (added in Visio 2010) |