Excel number formats allow you to define how a number will appear in your spreadsheet. | 1000 | General | | 1.0E+03 | 0.0E+00 | | $ 1,000.00 | $ #,###.00 | | 100000% | 0% |
Examples of Excel number formats. Excel number formats are also used to format dates and time information that has been stored as a number. | January 1, 2000 | mmmm d, yyyy | | 12:00 | hh:mm | | 01-Jan-00 12:00:00 | dd-mmm-yy hh:mm:ss |
Examples of Excel date formats. For more examples of Excel number formats, browse the Custom category in the Format  Cells... Number pane in Excel. |
