About Currency Constants
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
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.
|
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 (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 (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) |