Number format masks follow Java DecimalFormat.
See the Java 21 DecimalFormat documentation for the full pattern language.
| Symbol | Location | Localized | Meaning |
|---|---|---|---|
0 |
Number |
Yes |
Digit |
# |
Number |
Yes |
Digit, zero shows as absent |
. |
Number |
Yes |
Decimal separator or monetary decimal separator |
- |
Number |
Yes |
Minus sign |
, |
Number |
Yes |
Grouping separator |
E |
Number |
Yes |
Separates mantissa and exponent in scientific notation; need not be quoted in prefix or suffix |
; |
Sub pattern boundary |
Yes |
Separates positive and negative sub patterns |
% |
Prefix or suffix |
Yes |
Multiply by 100 and show as percentage |
\u2030 |
Prefix or suffix |
Yes |
Multiply by 1000 and show as per mille |
ยค ( |
Prefix or suffix |
No |
Currency sign, replaced by the currency symbol. If doubled, replaced by the international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator. |
' |
Prefix or suffix |
No |
Used to quote special characters in a prefix or suffix, for example, |
In a pattern, the exponent character immediately followed by one or more digit characters indicates scientific notation.
For example, 0.###E0 formats the number 1234 as 1.234E3.