Data Type in Excel
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.
Such as - A to Z letter, 0 to 9 number, symbol, date, time etc.
Number
This data type is used only to set digits (from 0 to 9), decimal points.
Currency
This data type is used to change the currency-related format in which decimal digits and currency symbols have to be set.
Like - Rs. 15,000, $ 500, Rs. 1500.00, Rs. 15000
Like - Rs. 15,000, $ 500, Rs. 1500.00, Rs. 15000
ConversionConversion EmoticonEmoticon