2022.2

Acustompatternthatmayconsistofsymbols;see"Numberpatterns"below.Notethattherepetitionof
patternlettersplaysapartindeterminingtheexactpresentation.
currencyNoSymbol(value)
Formatsanumberasacurrencywhilstomittingthecurrencysymbol.
value
Anumber.Notethatalldatafieldscontainstrings.Stringsneedtobeconvertedtoanumberbefore
passingthemtothisfunction.
grouped(value)
Formatsanumberusingathousandsseparator.WhichseparatorisuseddependsontheLocale,see
"Locale"onpage295.
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721.Thecustompatternmayconsistofpatterncharacters(seebelow),aprefixandasuffix.
Alldatafieldscontainstrings.
Notethat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
Page 740