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.