• Excel Video Tutorials

Setting Cell Type in Excel 2010


Advertisements

Formatting Cell

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 −

  • Right Click on the cell » Format cells » Number.
  • Click on the Ribbon from the ribbon.
Set Cell Type

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 like 17-09-2013, 17th-Sep-2013, etc.

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

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

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

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

  • Text − This displays cell as normal text.

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

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

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements