Setting Cell Type in Excel 2010

Formatting Cell

MS Excel Cell can hold different types of data pke Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below −

Right Cpck on the cell » Format cells » Number.

Cpck on the Ribbon from the ribbon.

Various Cell Formats

Below are the various cell formats.

General − This is the default cell format of Cell.

Number − This displays cell as number with separator.

Currency − This displays cell as currency i.e. with currency sign.

Accounting − Similar to Currency, used for accounting purpose.

Date − Various date formats are available under this pke 17-09-2013, 17^th-Sep-2013, etc.

Time − Various Time formats are available under this, pke 1.30PM, 13.30, etc.

Percentage − This displays cell as percentage with decimal places pke 50.00%.

Fraction − This displays cell as fraction pke 1/4, 1/2 etc.

Scientific − This displays cell as exponential pke 5.6E+01.

Text − This displays cell as normal text.

Special − Special formats of cell pke Zip code, Phone Number.

Custom − You can use custom format by using this.