Custom Formatting Rules on Numbers, Text,etc
Bonus:
| Number Code | Description |
|---|---|
| General | General number format. |
| 0 (zero) | Digit placeholder. This code pads the value with zeros to fill the format. |
| # | Digit placeholder. This code does not display extra zeros. |
| ? | Digit placeholder. This code leaves a space for insignificant zeros but does not display them. |
| . (period) | Decimal number. |
| % | Percentage. Microsoft Excel multiplies by 100 and adds the % character. |
| , (comma) | Thousands separator. A comma followed by a placeholder scales the number by a thousand. |
| E+ E- e+ e- | Scientific notation. |
