Decimal separator (edit)
https://docs.microsoft.com/en-us/globalization/locale/number-formatting
https://docs.oracle.com/cd/E19455-01/806-0169/overview-9/index.html
https://en.wikipedia.org/wiki/Decimal_separator
Design DB: https://drive.google.com/file/d/192_z-tMrVALw9rmWTdtTyBr1SDSwYp3H/view?usp=sharing
Number Formatting
-
The character used as the thousands separator.
In the United States, this character is a comma (,). In Germany, it is a period (.). Thus one thousand and twenty-five is displayed as 1,025 in the United States and 1.025 in Germany. In Sweden, the thousands separator is a space. -
The character used as the decimal separator.
In the United States, this character is a period (.). In Germany, it is a comma (,). Thus one thousand twenty-five and seven tenths is displayed as 1,025.7 in the United States and 1.025,7 in Germany.
The user can define preferred number-formatting parameters by making selections from the Numbers tab of the Customize Regional Options property sheet, within the Regional And Language Options property sheet. (See Figure 1 below.)
| Style | Countries and Regions |
|---|---|
| 1,234,567.89 | Canada (English-speaking; unofficial), China, Hong Kong, Ireland, Israel, Japan, Korea, Malaysia, Malta, Mexico, New Zealand, Pakistan, Philippines, Singapore, South Africa, Taiwan, Thailand, United Kingdom and other Commonwealth states, United States. |
| 1234567.89 | SI style (English version), Australia, Canada (English-speaking), China, South Africa, Sri Lanka, Switzerland (officially encouraged for currency numbers only[43]), United Kingdom. |
| 1234567,89 | SI style (French version), Albania, Belgium (French), Bulgaria, Canada (French-speaking), Croatia[44] the Czech Republic, Estonia, Finland, France, Hungary, Kosovo, Latin Europe, Latvia, Lithuania, Norway, Peru, Poland, Portugal, Russia, Slovakia, South Africa, Sweden, Switzerland (officially encouraged, except currency numbers[43]), Ukraine, Vietnam (in education). |
| 1,234,567·89 | Ireland, Malaysia, Philippines, Singapore, Taiwan, United Kingdom (older, typically hand written; in education) |
| 1,234.567,89 | Croatia (alternative to spaces; commas and periods alternate with powers of 1,000)[44] |
| 1.234.567,89 | Argentina, Austria, Belgium (Dutch), Bosnia and Herzegovina, Brazil, Chile, Colombia, Costa Rica, Croatia (informal), Denmark, Germany, Greece, Indonesia, Italy, Netherlands, Romania, Slovenia, Serbia, Spain,[45] Turkey, Vietnam. |
| 12,34,567.89 | Bangladesh, India (see Indian Numbering System). |
| 1'234'567.89 | Switzerland (computing), Liechtenstein. |
| 1'234'567,89 | Switzerland (handwriting). |
| 1.234.567'89 | Spain (handwriting, used until 1980's, inadvisable use according to the RAE). |
| 123,4567.89 | China (based on powers of 10 000—see Chinese numerals, also 1234567.89[citation needed]). |
