The number formatting is controlled by the following placeholders (characters)
| Character | Description |
|---|---|
| # | Placeholder that displays the digit of the value, if any. If fewer placeholders are used than the result is rounded. |
| 0 | Placeholder indicating the digit of the value, if any. If no digit is present, 0 (zero) is displayed in its place |
| . | Placeholder for the position of the decimal point |
| , | Placeholder specifying that the number is to be formatted with thousands separators. |
| % | Displays the number multiplied by 100. |
| ( | Displays an open parenthesis. |
| ) | Displays a closing parenthesis. |
| + | Displays the plus sign to the left of the number if the number is positive, or a minus sign if the number is negative. |
| - | Displays a minus sign to the left of the number if the number is negative. No effect for positive numbers. |
| E | Displays the number in scientific notation. |