PrecisionCalc
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 "1234567.89" will return:

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:

 

 

xlPrecision Home Page
PrecisionCalc Home Page