Date time Percentage in Excel

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, mm / dd / yyyy, yyyy / dd / mm, 23-July-2016, 23 july.



Time

 This data type is used to change the format related to 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 the 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 required.


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