Change the Formatting of Currency
The formatting of currency in an interview, including the input and output formats, and currency symbol, can be changed. To do this:
- On the Project tab, select the Language subtab.
- In the Region section of the language view, click Formatting.
The Edit Formats dialog box is displayed. The symbols used when specifying currency formats are given in the following table.
Symbol | Meaning |
---|---|
0 | mandatory digit |
# | digit, zero is omitted |
, | thousand grouping separator |
. | decimal separator |
¤ | currency symbol. If no currency symbol is specified it will automatically be added to the beginning of the string. |
All other characters will be treated literally. Any characters, including symbols enclosed in single quotes will also be treated literally. |
For example:
#,###,##0.00 #### (with “ “ a grouping separator, “.” as a decimal separator and “$” as a currency symbol)
- $1 234.00
- $0.12
#,###,##0.00 ####¤ (with “.“ a grouping separator, “,” as a decimal separator and “€” as a currency symbol)
- 1.234,00€
- 0,12€
To change the input format for currency:
- In the Currency section, click in the Input formats field.
- In the drop-down window:
- Click in the empty row to add a new currency format
- Select an existing row and click Delete to remove that currency format
- Change the order of input formats using the Up and Down buttons
To change the output format for currency:
- In the Currency section, click in the Output format field.
- Change the currency format as required.
To change the currency symbol:
- In the Currency section, click in the Currency symbol field.
- Change the currency symbol as required.