Specifies the decimal pattern. Reserved pattern letters are listed below:
Symbol | Description |
0 | digit (If no value found, set to zero) |
# | digit (If no value found, not set) |
. | digit delimiter |
, | group delimiter |
E | separates mantissa and exponent in scientific notation |
; | separates positive and negative sub patterns |
- | default negative prefix |
% | multiply by 100 and show as percentage |
X | other arbitrary characters can be placed at the front or end of the decimal |
' | used to quote reserved pattern letters in the prefix or suffix; for example, "'#'#" formats 123 to "#123" |