| 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. It also works to the right of the decimal point. It also suppresses the decimal point to the left if there is no
fractional part. |
| . |
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 %. |