| A | B |
|---|
| General | The default format; displays either text and numerical data as keyed |
| Number | Displays numerical data with a fixed number of places to the right of the decimal point |
| Currency | Displays numerical data preceded by a dollar sign |
| Accounting | Displays numerical data in currency format that lines up the dollar sign and decimal point vertically within a column |
| Date | Displays text and numerical data as dates |
| Time | Displays text and numerical data as times |
| Percentage | Displays numerical data followed by a percent sign |
| Fraction | Displays numerical data as fractional values |
| Scientific | Displays numerical data in exponential notation |
| Text | Displays numerical data that will not be used for calculation, such as serial numbers containing hyphens |
| Special | Displays numerical data that requires a specific format, such as ZIP codes or phone numbers |
| Custom | Displays formats designed by the user, including formats with commas or leading zeros |
