| 0 |
digit or lead zeroes |
| # |
digit or nothing at all. There is no pattern character to provide lead
spaces for creating a fixed length pattern. |
| . |
decimal point. Actual character displayed is locale-specific, though the
character you specify for the pattern is always a dot, e. g. in Sweden this will
display as a comma. |
| , |
comma for grouping digits. Actual character displayed is locale-specific,
though the character you specify for the pattern is always a docomma, e. g. in
Sweden this will display as a period. |
| E |
exponent separator. |
| ' |
used to surround decorative characters, including embedded spaces, e. g. "'$'###,##0.00" |
| ; |
Used to separate the pattern for positive numbers from the pattern for
negative numbers. |
| % |
display a ratio as a percentage. As in "##0.0%",
multiplies the displayed value by 100 and displays a decorative trailing %. |