Global Sourcebook for International Data Management

                                         by Graham Rhind

Help us to keep this resource free!
Support/Advertise/Donate

_____


_____

Related services
_____
With Smart Customer
MDM, Uniserv is a leading
expert in successful data
and data quality
management

____

This resource is also available as a PDF file

Number formats

Global Sourcebook | Index | Properties

Tips for practical management of number data External

Table of Contents

Separators

The format in which numbers may be written differs by culture/country. Differences are mainly in the separators used to indication thousands and decimals. Some formats used include:

Number format
Albania 1.234,45
Algeria 1234.45
Argentina 1.234,45
Armenia 1234.45
Australia 1234.45
Austria 1.234,45
Azerbaijan 1 234,45
Belarus 1 234,45
Belgium 1.234,45
Belize 1234.45
Bolivia 1.234,45
Brazil 1.234,45
Bulgaria 1 234,45
Canada 1 234,45
1234.45
Chile 1.234,45
China 1234.45
Colombia 1.234,45
Costa Rica 1.234,45
Croatia 1.234,45
Czechia / Czech Republic 1 234,45
Denmark 1.234,45
Dominican Republic 1234.45
Ecuador 1.234,45
El Salvador 1234.45
Estonia 1 234.45
Finland 1 234,45
France 1 234,45
Georgia 1 234,45
Germany 1.234,45
Greece 1.234,45
Hong Kong 1234.45
Hungary 1 234,45
Iceland 1.234,45
India 1234.45
Indonesia 1.234,45
Iran 1,234/45
Iraq 1234.45
Ireland 1234.45
Israel 1234.45
Italy 1.234,45
Jamaica 1234.45
Japan 1234.45
Kazakhstan 1 234-45
Kenya 1234.45
Kyrgyzstan 1 234-45
Latvia 1 234,45
Lebanon 1234.45
Liechtenstein 1'234.45
Lithuania 1.234,45
Macao 1234.45
Macedonia 1.234,45
Malaysia 1.234,45
Mexico 1234.45
Monaco 1 234,45
Mongolia 1 234,45
Netherlands 1.234,45
New Zealand 1234.45
Nicaragua 1234.45
North Korea 1234.45
Norway 1 234,45
Pakistan 1234.45
Paraguay 1.234,45
Peru 1234.45
Philippines 1234.45
Poland 1 234,45
Portugal 1.234,45
Puerto Rico 1234.45
Romania 1.234,45
Russia 1 234,45
Saudi Arabia 1234.45
Serbia 1.234,45
Slovakia 1 234,45
Slovenia 1.234,45
South Africa 1234.45
South Korea 1234.45
Spain 1.234,45
Sweden 1.234,45
Switzerland 1'234.45
Syria 1234.45
Taiwan 1234.45
Thailand 1234.45
Trinidad and Tobago 1234.45
Turkey 1.234,45
Ukraine 1 234,45
United Kingdom 1234.45
United States of America 1234.45
Uruguay 1.234,45
Uzbekistan 1 234,45
Venezuela 1.234,45
Vietnam 1.234,45

Negative Numbers

Negative numbers can be displayed in several ways: using the negative sign (before or after the number), using brackets/parentheses or printing them in red, often depending on context. We do not have information about how these differ on a country-by-country basis. For example:

   -123
   123-
   (123)
   [123]
   123

Numbers in different scripts

Numbers are written differently in different scripts. For example:

Script Example numbers
Latin 0123456789
Arabic ٠‎ ١‎ ٢‎ ٣‎ ٤‎ ٥‎ ٦‎ ٧‎ ٨‎ ٩
Bengla ০ ১ ২ ৩ ৪ ৫ ৬ ৭ ৮ ৯
Chinese and Japanese 〇 一 二 三 四 五 六 七 八 九 十
Devanagari ० १ २ ३ ४ ५ ६ ७ ८ ९
Gujarati ୦ ୧ ୨ ୩ ୪ ୫ ୬ ୭ ୮ ୯
Gurkukhi ੦ ੧ ੨ ੩ ੪ ੫ ੬ ੭ ੮ ੯
Hebrew א ,ב ,ג, ד, ה, ו, ז, ח ,ט
Kannada ೦ ೧ ೨ ೩ ೪ ೫ ೬ ೭ ೮ ೯
Korean 일 이 삼 사 오 육 칠 팔 구 or 하나 둘 셋 넷 다섯 여섯 일곱 여덟 아홉
Malayalam ൦ ൧ ൨ ൩ ൪ ൫ ൬ ൭ ൮ ൯
Odia ୦ ୧ ୨ ୩ ୪ ୫ ୬ ୭ ୮ ୯
Tami ௦ ௧ ௨ ௩ ௪ ௫ ௬ ௭ ௮ ௯
Telugu ౦ ౧ ౨ ౩ ౪ ౫ ౬ ౭ ౮ ౯
Thai ๐ ๑ ๒ ๓ ๔ ๕ ๖ ๗ ๘ ๙
Tibetan ༠ ༡ ༢ ༣ ༤ ༥ ༦ ༧ ༨ ༩

They might contain different number sets - some scripts, for example, have a separate glyph to indicate the number 10.

Digit grouping

Note that not all cultures group digits in groups of three, for example:

   1,203,254.25

Hindi, for example, groups digits in twos except for a three-digit grouping to denote hundreds:

   12,03,254.25

For more information see docs.microsoft.com/en-us/globalization/locale/number-formatting External


Every effort is made to keep this resource updated. If you find any errors, or have any questions or requests, please don't hesitate to contact the author.

All information copyright Graham Rhind 2017. Any information used should be acknowledged and referenced.