Decimal format symbols
|
Symbol |
Meaning |
|---|---|
|
0 |
A digit that is shown even if the value is zero. |
|
# |
A digit that is suppressed if the value is zero. |
|
. |
A placeholder for decimal separator. |
|
, |
A placeholder for thousands grouping separator. |
|
E |
Separates mantissa and exponent for exponential formats. |
|
; |
Separates formats for positive numbers and formats for negative numbers. |
|
- |
The default negative prefix. |
|
% |
Multiplied by 100, as percentage. |
|
|
Multiplied by 1000, as per mille. |
|
|
The currency symbol. If this symbol is present in a pattern, the monetary decimal separator is used instead of the decimal separator. |
|
|
The international currency sign. It will be replaced by an international currency symbol. If it is present in a pattern, the monetary decimal separator is used instead of the decimal separator. |
|
X |
Other characters that can be used in the prefix or suffix. |
|
' |
Used to quote special characters in a prefix or suffix. |
|
/u221E |
Infinity symbol. |
|
/uFFFD |
Not a Number symbol. |
