About Currency Constants

Last modified: February 11, 2014

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)

Show:
© 2014 Microsoft