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 versions 2017 & 2018 (on editions that offer internationalized thousands separator formatting) add support for the Indian numbering system's digit grouping, which unlike the International numbering system, groups every two digits after the first group of three digits:

1,00,00,00,000.000001

Not only that, these versions of xlPrecision will use any numbering system selected in the Windows Regional control panel for Currency Digit Grouping.

In fact, these versions of xlPrecision even allow you to enter your own custom digit grouping code! You'll find it in the About box by clicking the new "Set Groupings" button:

Note this support for the Indian numbering system's digit grouping and support for custom override digit grouping is a feature of xlPrecision versions 2017 & 2018. It is not included in classic versions 3.x.x. Versions 2017 & 2018 require a new xlPrecision.xla add-in file that you have to copy in manually, so to avoid confusion you get the classic 3.x.x when you buy xlPrecision unless you specify 2018. Of course, if you buy a classic version 3.x.x and want version 2018, it's a free upgrade on request. Eventually when the Free Edition is upgraded to version 2018, everyone will be sent that version and no one will have to manually copy in a new xlPrecision.xla add-in file.

 

 

 

xlPrecision Home Page
 PrecisionCalc Home Page