xl Precision
Get Your Numbers Right

Internationalized Thousands Separator Formatting

On editions that offer internationalized thousands separator formatting, setting the format_thousands argument to TRUE adds the local thousands separator to the calculation result.

This means that an xlPrecision formula that returns "1,234,567.89" in the USA will return:

• "1.234.567,89" in Germany
• "1 234 567,89" in France
• "1 234 567.89" in Estonia

Regardless of xlPrecision edition, the decimal symbol is always internationalized.

On editions that don't offer internationalized thousands separator formatting, the format_thousands argument is ignored, so the same formula would return:

• 1234567.89 in the USA
• 1234567,89 in Germany and France