Number Group

Hello Friends, Happy Friday
After a long time i come to show you how can we use "Number Group" in Home Tab
.
With the help of this group we can change the " format of  text" for example i just type a number in any cell of excel and want to use this number as a date so simply i can choose "Date" option from the list of number format.

Let's understand it by a example:


In this picture, if you observe the format "Starting date" and "End Date" is "Date" and in Duration you can observe that given content is a number. This is all because of Number format. Actually Excel take every date as a number and for Excel

01 January 1900 = 1
02 January 1900 =2
.............
.............
..............


this way every date has a special number and excel use it as a number but for us it format its like a date. so when we use a formula to get duration is work as a number and give a result in a number format and if we change the format of Duration let's see what will happen:




We can clearly see that for Excel:

629 = 09/20/1901
351 = 12/16/1900
102 = 04/11/1900
30 =  01/30/1900
304 = 10/30/1900


So, i hope you have understood the use of number format. In my next post i'll share how can we work on decimal numbers with decimal format. Till then Bye have a nice day.

Comments

Post a Comment

Popular posts from this blog

Font Group

Image
Hii Friends, Yesterday, we have talked about the "clipboard Group" in "Home Tab". But Today we will know about the next group of  Home Tab in MS EXCEL. It is "Font Group". It is very simple and easy to use tool. We can simply understand every option of it. But still i want to explain every thing so that you don't have any problem/doubt to use it. Let's start............. It looks like this  1. Font "Calibri" is the type of Font. In simple language we can say that if we change the font, we change style of writing. For Example if i select a filled cell and then change the font............ take a look what happens. It is the "Calibri" font but if change it by clicking on down arrow near "Calibri", look what happens..  So, you can watch that the style of font has changed. Simply we can change it in several styles.  Note: "For Select any cell you will have to left click on them by mouse. But if you want to select more...
Read more

Border In Sheet

Image
Today we will know about a very useful thing about excel sheet. Generally we create any sheet in excel and print it but without border it will not look pretty and the document will not get a professional look. Therefor it is compulsory that we use "Border Option". Take a look if do not use border then how will our print preview.... Here, i note some records but if we print and it we don't find it in proper manner. Let's check it by print preview.... After Select "Print Preview" we will found the following result....... Here, records are not in proper way also not looking good. So if we want to give it a proper look we have to use "Border" option in "Home Tab" "Font Group"  When put your mouse cursor on the down-arrow of  border option you will get a list that which type of border do you need?? for example: If you need only "Top and Bottom Border" then select the cells on which you want to border and then select the opt...
Read more