| 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 %. |