2018.1

grouped(value)
Formats a number using a thousands separator. Which separator is used depends on the
Locale, see "Locale" on page276.
value
A number. Note that all data fields contain strings. Strings need to be converted to a number
before passing them to this function.
Number patterns
Numbers, used in a template, can be displayed using a custom pattern.
In the Script Editor, the pattern can be passed to a function of the formatter; see "formatter" on
page666. The custom pattern may consist of pattern characters (see below), a prefix and a
suffix.
Note that all data fields contain strings. Strings need to be converted to a number before they
can be formatted this way.
The repetition of pattern letters determines the exact presentation. For example, the pattern
"00000" limits the number to 5 digits and adds leading zeros to any numbers that are not 5
digits long.
Pattern characters
Symbol Location Localized? Meaning
0 Number Text Digit
# Number Year Digit, zero shows as absent
. Number Year Decimal separator or monetary decimal separator
- Number Month Minus sign
, Number Number Grouping separator
E Number Number Separates mantissa and exponent in scientific
notation. Need not be quoted in prefix or suffix.
Page 679