Ms Excel in Data Types for beginners

Many types of data can be filled in an Excel worksheet. To fill a particular type of data in a cell of a worksheet, we have to format that cell to store and display that data before formatting the cells. It is necessary to understand the data type properly.

To set the data type, one has to select Row Column or Aria. After this the data type has to be set. There are twelve types of data types in Excel. But some of those data types are more important, mainly the following data types are used in Excel which is as follows.

General: - This data type is used to store all types of data. This is a common data type.

Such as - A to Z letter, 0 to 9 number, symbol, date, time etc

Number: - This data type is used to set only digits (from 0 to 9), decimal digits.

Currency: - This data type is used to change the currency related format, it has to set decimal digits and currency symbol. Like - Rs. 15,000, $ 500, Rs. 1500.00, Rs. 15000

Date: - This data type is used to change the format related to the date in which the format of the date is to be selected. Such as - dd / mm / yyyy,   dd / mm, yyyy / dd / mm, 23-July-2016, 23 July.

​ Time: - This data type is used to change the format related to the time in which the format of the time is to be selected.

Percentage: - This data type is used to change the format related to Percentage. It also has to set decimal points. It has a Percentage symbol.

Scientific: - Number data type is stored in this data type. It has to set decimal digits.

Text : - This data type is used to change the format related to TEX, in which mathematical calculations cannot be done.

Special: - This data type is used to store special types of data. Zip codes and phone numbers etc. are stored.

Accounting: - This data type is used to store data related to account. In this, the decimal points have to be set and the currency symbol has to be selected.

Custom: - In this data type, you can set the type of data as per the requirement.