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.
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.