Separators

Technical Articles > Formatting Text by using Number Formats

Two separators can be applied to display a number as a decimal number or/and to render with a thousands separator. Depending on the system language, the separator signs are rendered with the system's default digit or thousands separator signs (e.g. a German system uses comma as decimal sign and point as thousand separator).

Decimal Numbers

To specify a number format where all numbers are displayed with decimal places, the placeholder must be combined with a digit point ('.'). The number of placeholders following that separator determines the maximum number of decimal places to be shown. If no digit point is set, results are rounded to the next integer value.

Examples:
Formatting 12.6 with #.## will be displayed as 12.6.
Formatting 5 with #.00 will be displayed as 5.00.
Formatting 12.6 with #.00 will be displayed as 12.60.
Formatting 0.543 with #.00 will be displayed as 0.54.
Formatting 17.548 with # will be displayed as 18.

Thousands Separator

Another separator is the thousands separator (','). Using this character in combination with appended placeholders, the displayed result of the calculation is rendered with a comma at each third digit. If no placeholder is set behind the comma, for each comma the number is trimmed by three pre-decimal point positions.

Examples:
Formatting 9876543210.1234 with ,###.## will be displayed as 9,876,543,210.12.
Formatting 9876543210 with ,### will be displayed as 9,876,543,210.
Formatting 12200000 with #,, will be displayed as 12.
Formatting 12200000 with #.0,, will be displayed as 12.2.