Currency Formatting

03/16/2016

2 minutes to read





In this article

Currency formatting needs to take into consideration these following elements:

Currency symbol — This can be a pre-defined symbol such as the European Euro '€' or a combination of letters like the use of 'GBP' for British Pound.

— This can be a pre-defined symbol such as the European Euro '€' or a combination of letters like the use of 'GBP' for British Pound. Currency symbol placement — It can be either place before or after the digits.

— It can be either place before or after the digits. Negative-amount display — Several of the ways to display negative amounts are:

Description Country Formatting The negative sign before both the currency symbol and number. UK -£127.54 France -127,54 € The negative sign before the number but behind the currency symbol. Denmark kr-127,54 The negative sign after the number. Netherlands € 127,54- The use of parentheses. US ($127.54)

Most currencies use the same decimal and thousands separator that the numbers in the locale use, but this is not always true. In some places in Switzerland, they use the period as a decimal separator for Swiss frans (Sfr. 127.54), but then use commas as the decimal separator everywhere else (127,54).

Figure 1. Currency format in Region settings