Change the Formatting of Numbers

The formatting of numbers in an interview, including the input and output formats, grouping separators and decimal separators, can be changed. To do this:

  1. On the Project tab, select the Language subtab.
  2. In the Region section of the language view, click Formatting.

The Edit Formats dialog box is displayed. The symbols used when specifying number formats are given in the following table.

Table 1. Number format symbols
Symbol Meaning
0 mandatory digit
# digit, zero is omitted
, thousand grouping separator
. decimal separator
All other characters will be treated literally. Any characters, including symbols enclosed in single quotes will also be treated literally.

For example:

#,###,##0.###### (with “ “ as a grouping separator and “.” as a decimal separator) would be:

  • 1 234 567
  • 0.123

#,###,##0.0##### (with “.“ a grouping separator and “,” as a decimal separator)

  • 1.234.567,0
  • 0,123

To change the input format for numbers:

  1. In the Numbers section, click in the Input formats field.
  2. In the drop-down window:
    • Click in the empty row to add a new number format
    • Select an existing row and click Delete to remove that number format
    • Change the order of input formats using the Up and Down buttons

To change the output format for numbers:

  1. In the Numbers section, click in the Output format field.
  2. Change the number format as required.

To change the grouping separator for numbers:

  1. In the Numbers section, click in the Grouping separators field.
  2. In the drop-down window:
    • Click in the empty row to add a new grouping separator, and /or
    • Select an existing row and click Delete to remove that grouping separator.

To change the decimal separator for numbers:

  1. In the Numbers section, click in the Decimal separator field.
  2. Change the decimal separator as required. Note that the decimal separator cannot be the same as the grouping separator.