Excel 简明教程

Setting Cell Type in Excel 2010

Formatting Cell

Microsoft Excel 单元格可以容纳多种类型的数据，例如数字、货币、日期等。您可以使用以下所示的多种方式设置单元格类型 −

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

  1. Right Click on the cell » Format cells » Number.

  2. Click on the Ribbon from the ribbon.

set cell type

Various Cell Formats

以下是不同的单元格格式。

Below are the various cell formats.

  1. General − This is the default cell format of Cell.

  2. Number − This displays cell as number with separator.

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

  4. Accounting − Similar to Currency, used for accounting purpose.

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

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

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

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

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

  10. Text − This displays cell as normal text.

  11. Special − Special formats of cell like Zip code, Phone Number.

  12. Custom − You can use custom format by using this.