2020.2

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.
; Subpattern
boundary
Number Separates positive and negative
subpatterns
% Prefix or suffix Number Multiply by 100 and show as percentage
\u2030 Prefix or suffix Number Multiply by 1000 and show as per mille
value
¤ (\u00A4) Prefix or suffix Number Currency sign, replaced by currency
symbol. If doubled, replaced by
Page 803