| A | B |
|---|
| # | Digit placeholder. Displays only significant digits and does not display insignificant zeros. |
| 0 (zero) | Digit placeholder. Displays only insignificant zeros if a number has fewer digits than there are zeros in the format. |
| ? | Digit placeholder. Adds spaces for insignificant zeros on either sideof the decimal point so that decimal points align when formatted with a fixed-width font. |
| . | Decimal point. |
| % | Percentage. |
| , | Thousands separator. |
| E- E+ e- e+ | Scientific notation. |
| $ - + / () : space | Displays this character. |
| \ | Displays the next character in the format. |
| * | Repeats the next character to fill the column width. |
| _ (underscore) | Leaves a space equal to the width of the next character. |
| "text" | Displays the text inside the double quotation marks. |
| @ | Text placeholder. |
| [color] | Displays the characters in the color specified. |
| [Color n] | Displays the corresponding color in the color palette, where n is a number from 0 to 56. |
| [condition value] | Set your own criterion for each section of a number format. |
