Data Type in Excel

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.




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



Previous
Next Post »

Featured Post

Changing the background of selected slides of the presentation

Changing the background of selected slides of the presentation The following options are used to insert different backgrounds on differe...