Creating international number formats
Applies to
Microsoft Excel 2002
Microsoft Office Excel 2003

You can customize the numbers in your workbook so they represent different international locations or are displayed in a unique format for a particular locale. Custom locale formats can be created for dates, times, and special numbers like postal codes, phone numbers, and social security numbers.

Create a custom international number format

  1. Select the cells you want to format.
  2. On the Format menu, click Cells.
  3. On the Number tab, click the type of number format you would like to create in the Category box (for example, Date).
  4. In the Locale (location) box, select the locale you want.
  5. In the Type box, select a format.
  6. In the Category box, click Custom.

The code for the format you selected appears in the Type box. This will be your starting point for the new number format.

  1. To customize the number format, make changes to the code components (as described in the following section), and then click OK.

The new format will now be available in the Type list of the Custom category.

Changing number format code components

You can customize a number format by adding or changing codes for the the following components:

For example, before you make any changes, a format code for a date may look like this:

m/d/yy

If you specify a different locale before you select a format, a locale component will be added to the code, in brackets, and the resulting format code may look like this:

[$-412]m/d/yy

If you add calendar and numeral shape components to the locale component, in the brackets, the new format code may look like this:

[$-24050412]m/d/yy

In the preceding example:

24  is the numeral shape component (Korean 1).
05  is the calendar type component (Korean (Tangun era)).
0412  is the locale and language designation component (Korean).

Changing a locale before selecting a format automatically adds the locale and language designation to the number format code. You can change this component, add a numeral shape component, or add a calendar type component by using the codes listed in the tables below.

 Note   If you enter a 0 value for one of the components, Excel applies the system settings for that component, as specified in Regional and Language Options, in Control Panel.

Numeral shape codes

The numeral shape code determines what the numbers will look like in the formatted cells. The following table contains the possible values for this component of the locale specifier:

Hexadecimal
value
Numeral shape
01 Western
02 Arabic Indic
03 Extended Arabic Indic
04 Devanagari
05 Bengali
06 Gurmukhi
07 Gujarati
08 Oriya
09 Tamil
0A Telugu
0B Kannada
0C Malayalam
0D Thai
0E Lao
0F Tibetan
10 Myanmar
11 Ethiopic
12 Khmer
13 Mongolian
1B Japanese 1
1C Japanese 2
1D Japanese 3
1E Simplified Chinese 1
1F Simplified Chinese 2
20 Simplified Chinese 3
21 Traditional Chinese 1
22 Traditional Chinese 2
23 Traditional Chinese 3
24 Korean 1
25 Korean 2
26 Korean 3
27 Korean 4

Calendar type codes

The calendar type code allows you to select which calendar will be applied to the number format. The following table contains the possible values for this component of the locale specifier:

Hexadecimal
value
Calendar type
01 Gregorian (Localized)
02 Gregorian (United States)
03 Japanese (Emperor era)
04 Taiwanese
05 Korean (Tangun era)
06 Hijri (Arabic lunar)
07 Thai
09 Gregorian (Middle East French)
0A Gregorian (Arabic)
0B Gregorian (Transliterated English)

Locale and language designation codes

The locale and language designation code component allows you to specify which locale should be applied to the number format. This number requires the hexadecimal value of the Locale Identifier (LCID) for the appropriate language and location. The following table lists the languages supported by Microsoft Office and the corresponding LCIDs and hexadecimal values.

Once the locale specifier has been added to a number format, numbers typed in the formatted cells will be formatted using the appropriate locale-specific information.

Hexadecimal
value
Language LCID
0401 Arabic 1025
0402 Bulgarian 1026
0403 Catalan 1027
0404 Chinese (Traditional) 1028
0405 Czech 1029
0406 Danish 1030
0407 German 1031
0408 Greek 1032
0409 English (U.S.) 1033
040B Finnish 1035
040C French 1036
040D Hebrew 1037
040E Hungarian 1038
040F Icelandic 1039
0410 Italian 1040
0411 Japanese 1041
0412 Korean 1042
0413 Dutch 1043
0414 Norwegian Bokmal 1044
0415 Polish 1045
0416 Portuguese (Brazil) 1046
0418 Romanian 1048
0419 Russian 1049
041A Croatian 1050
041B Slovak 1051
041C Albanian 1052
041D Swedish 1053
041E Thai 1054
041F Turkish 1055
0420 Urdu 1056
0421 Indonesian 1057
0422 Ukrainian 1058
0423 Belarusian 1059
0424 Slovenian 1060
0425 Estonian 1061
0426 Latvian 1062
0427 Lithuanian 1063
0428 Tajik 1064
0429 Persian 1065
042A Vietnamese 1066
042B Armenian 1067
042C Azeri (Latin) 1068
042D Basque 1069
042F Macedonian FYROM 1071
0436 Afrikaans 1078
0437 Georgian 1079
0438 Faeroese 1080
0439 Hindi 1081
043A Maltese 1082
043D Yiddish 1085
043E Malay 1086
043F Kazakh 1087
0440 Kyrgyz 1088
0441 Swahili 1089
0442 Turkmen 1090
0443 Uzbek (Latin) 1091
0444 Tatar 1092
0445 Bengali 1093
0446 Punjabi 1094
0447 Gujarati 1095
0448 Oriya 1096
0449 Tamil 1097
044A Telugu 1098
044B Kannada 1099
044C Malayalam 1100
044D Assamese 1101
044E Marathi 1102
044F Sanskrit 1103
0450 Mongolian 1104
0456 Galician 1110
0457 Konkani 1111
0458 Manipuri 1112
0459 Sindhi 1113
045A Syriac 1114
045B Sinhalese 1115
045C Cherokee 1116
045D Inuktitut 1117
045E Amharic 1118
045F Tamazight (Arabic) 1119
0460 Kashmiri (Arabic) 1120
0461 Nepali 1121
0462 Frisian 1122
0463 Pashto 1123
0464 Filipino 1124
0465 Dhivehi 1125
0466 Edo 1126
0467 Fulfulde 1127
0468 Hausa 1128
0469 Ibibio 1129
046A Yoruba 1130
0470 Igbo 1136
0471 Kanuri 1137
0472 Oromo 1138
0473 Tigrigna (Ethiopia) 1139
0475 Hawaiian 1141
0476 Latin 1142
0477 Somali 1143
0478 Yi 1144
0804 Chinese (Simplified) 2052
0807 German (Swiss) 2055
0809 English (U.K.) 2057
0814 Norwegian Nynorsk 2068
0816 Portuguese (Portugal) 2070
081A Serbian (Latin) 2074
082C Azeri (Cyrillic) 2092
0843 Uzbek (Cyrillic) 2115
0873 Tigrigna (Eritrea) 2163
085F Tamazight (Latin) 2143
0C07 German (Austrian) 3079
0C09 English (Australian) 3081
0C0A Spanish 3082
0C0C French (Canadian) 3084
0C1A Serbian (Cyrillic) 3098
1009 English (Canadian) 4105
See Also:
See Also: