Excel Number Formats
Accounting
Displays numbers in the Currency format but lines up the dollar signs and the decimal points vertically within a column.
Currency
Displays numbers preceded by a dollar sign with a thousands separator and two decimal places.
Number
Displays numbers with a fixed number of places to the right of the decimal point; the default is two decimal places
Special
Displays numbers with a specific format: zip codes, zip+4 codes, phone numbers, and Social Security Numbers
Percentage
Displays numbers with two decimal polaces followed by a percent sign
Text
Displays text and numbers exactly as you type them.
Date
Displays texts and numbers as dates
Time
Displays texts and numbers as time
Custom
Displays data in the formay you create,such as with commas or leading zeros
Fraction
Displays decimal numbers as fraction
Scientific
Displays numbers in explonential (or scientific) notation
General
The default format; displays numbers as typed. If the number doesn;t fit in the cell, decimals are rounded, or the number is converted to scientific notation.