Number Formatting

When dealing with numeric values, there are six major items to pay attention to:
  1. 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.

  2. 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.

  3. The way negative numbers are displayed.

    The negative sign can be used at the beginning of the number, but it can also be used at the end of the number. Alternatively, the number can be displayed with parentheses around it or even in a color such as red. Thus a negative five hundred and twenty-seven could be displayed as:  


    negative number
  4. The shape of the numbers, or whether they have a one-to-one correspondence to the decimal set of digits.

    Numbers might, of course, be shaped differently from one locale to another. Also, numbers in some locales might not correspond directly to there digits (0-9) used in, say, the United States. (See Table 1 below) 


    digit shape

    Table 1: Digits used for English (United States), Arabic, and Japanese locales.

  5. Note how Japanese has one more digit than Arabic or English (United States). This represents the number 10.

  6. Digit grouping.

    This refers to the number of digits contained between each separator for all digit groups that appear to the left of the decimal separator. For example, the 3-digit group is used for most cultures, such as for English (United States): 123,456,789.00. However, notice that Hindi uses a 2-digit grouping, except for the 3-digit grouping for denoting hundreds: 12,34,56,789.00

  7. The placement of the percent sign (%).

    It can be written several ways: 98%, 98 %, 98 pct, %98. Thus you should never assume that you can hard-code the percent sign.

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.)

Number Format 

Figure 1: Selecting the preferred number formatting.

See more info in the below links: