| A | B |
|---|
| Accounting Number Format | Adds a dollar sign to the left, separates thousands with a comma, displays the value with two digits to the right of the decimal point. |
| Percent Style | Displays the value as a percentage. |
| Comma Style | Separates thousands with a comma. |
| Decrease Decimal | Increases the number of digits to the right of the decimal point by one. |
| Decrease Decimal | Decreases the number of digits to the right of the decimal point by one. |
| Ctrl+Shift+~ | General number format |
| Ctrl+Shift+! | Two decimal places, thousands separator, and a hyphen for negative values. |
| Ctrl+Shift+@ | Time format with the hour; minute, and AM or PM. |
| Ctrl+Shift+# | Date format with the day, month, and year. |
| Ctrl+Shift+$ | Currency format with two decimal places. |
| Ctrl+Shift+% | Percentage format with no decimal places. |
| Ctrl+Shift+^ | Scientific notation number format with two decimal places. |
| General | The default format. |
| Number | Specify the number of decimal places, whether to use your system thousands separator, how to display negative numbers. |
| Currency | Specify the number of decimal places, choose a currency symbol. |
| Accounting | Differes from the Currency format in that the currency symbols always line up vertically. |
| Date | Choose from a variety of date formats. |
| Time | Choose from a variety of time formats. |
| Percentage | Choose the number of decimal places; always displays a percent sign. |
| Fraction | Choose from among nine fraction formats. |
