hello and welcome to our new video in this video we are
going to learn how to do number formatting in excel what is
number format so what i will do i will open excel you all
already know how to open excel open excel everything is
clear so what i will do i will open excel in excel file i
have date, time number, currency money, percentage, tax so
what we are going to understand we know what is home what
is tab clipboard, font, alignment so we are number group
you can see gender option we are
to explore this option we are going to explore this option
before that my friend asked me do you know excel? so i said
yes so he said ok so i said ok so i said 0 9 8 7 6 5 so he
said press enter so i said yes so he said no so i said 0 9
8 7 6 5 so he said press enter so i said 0 9 8 7 6 5 so i
said 0 9 8 7 6 5 so he said no so he said no so he said
none so he said none so he said none so he added 23 so he
added 23 so what is taxi so what is taxi
So, now here what is that my tax is
How can I write my number in the form of tax
Showing in the form of tax means that
Now the problem of zero was coming to us
That we put zero here and that zero disappeared
When we pressed the enter button
If we write this number in the form of tax
So what will he consider
He will not consider this number as a number
He will consider this number as a tax
Now you will say, sir, what did you tell so much
So we will come back to it
You have an idea what I am trying to say
What is the problem in front of us
That I am writing zero five times on you
So what is he taking
He is taking zero once
And here I put zero in front of it
So what happened
He removed the zero
So we are going to see all these things now
So let's understand one by one
Let's understand from the date
Now the date is mine
We know that the format of the date can be different
Can be different formats
For example, the date today
I put that date
Two And here I put
Two Two And two thousand twenty three
I entered
So what did he take
Two February twenty three
How did I put
I put two two twenty three
How did he take
Two February twenty three
So let's go to this option
What did he take by default
By default
The format that I had put
How did he take it
Let's do one more thing
If I put three
I put zero three
Zero two
Will he support this format too
I did
Enter So he wrote
Three February
How did I write in the starting format
In the starting format
I wrote something like this
I wrote here zero two
And I put the hyphen sign
Zero two
And two thousand twenty three
So what did he give me
And how did I write this date
I wrote zero two
And here I wrote
Zero three
And here I put the sign
Slash Zero two twenty three
So what did he give me
He gave me
Three February like this
So he gave it in different ways
Are you able to understand
Now why does this happen
Now this format
What was written before
Now see here
You will get to see many things
Like general
What is written in general
No specific format
Number Currency Accounting Date No specific format
Generally excel
He does what he understands
If he does not understand
He gives wrong answers
He starts doing things in other formats
Like here it was general
So what was the problem
See in general
One thing
The date that was written
Because he took which format
He took the number format
Are you able to understand
So let's understand this one by one
Why does it do
So we always have to remember one thing
If we are writing something in time
Or we are writing something in date
Like I wrote here three February
So I always have to remember this thing
That I will go here
And select the date format
Whether it is short date format
Or long date format
Let's remove it and do it again
I have removed it completely
I have deleted it
Now I am writing here again
I am writing here 2 February 2023 When I did it here and
entered
So he took it like this
Now it is showing custom
So what I have to do here
I have to go here
And here I have to do short date
How does it show in short date
It shows in short date 020223 Which means the format in
which I put
What is that format
That is short format
And if I have to do the same thing in long format
So what I will do
I will go back here
So it will show me 02 February 2023
So till now we have understood
If I have to bring this date in the cells below 02 February
03 February 04 February
So you know how we do it What we do is
We go to this plus sign
And we drag it 03 February, 04 February, 05 February 06
February
Now we don't want this whole thing in this format
We want this in short format
We don't like this format
So what we will do
We go back here
And we put short date
And this whole thing got converted in Short date
So till here I think
No one should have any doubt
No one has any doubt till here After this let's see one
thing
Suppose this is the date format
And date format If I write in any other format
Then what is the problem
Let's see this So what I did, I selected this whole thing
And I don't format the date
I format it wrong
So I do currency here
So what is this
It came in currency
And what happened in currency
My data also changed
What did I write here
I wrote 02 February 2023
What is coming here 44,959 So now we have to correct this
So to correct this
What we will do again
We will do the date format
And what will happen
It will be corrected
So till here it is clear
What we were doing
After that we shift How does time work?
We know that UK time is 5.5 hrs or 4.5 hrs or other
countries time is more than ours
So we have to remember one more thing that if we want to
subtract or minus
We have to subtract time from time
For example, if I say subtract 2 hours from 6 hours, how
many hours are left?
You will say 4 hours are left
So now you are able to get the answer in 4 hours when you
subtract time from time
From the time format
It should not be that you are subtracting the number format
from the time format
So what will happen?
It will be very difficult
We have seen here also that if we change this format
It will take the wrong number
It will take the wrong input
So let's put any time here
I have put 04
And here I have put 4
It's been 2 minutes
I have put enter
Now what do we know?
Is this AM or PM?
What is this?
I don't know what is this
So what we will do
If we tell this
What is the format I have written?
If this is the time format
So what will it do?
It will automatically correct it
So I go here
And see where the time is written
So I found this time
But it gave us like this 40200 I still don't know
AM or PM
So what will I do?
Here you are seeing
There is a button
I told you that
All things
Can't be grouped here
So what do we do?
We show the important things here
And hide the rest of the things
So if you want to see the rest of the things
So what do you have to do?
You have to go to this small button
And click
Now here you will see one thing
Here you will see
The sample is written
I have put the sample here
The sample is written here
And here
What is given?
The format is given
And the location is also given
English India
You say English India
Is Hindi India also available?
Yes, Hindi India is also available
Let's do Hindi India
Where will you get Hindi India?
We went to Hindi
If we do Hindi
What is this in Hindi?
Let's do it
Purvahan 4 2 minutes
Purvahan means evening time
Let's do it again
Control plus Z
You know the mistake
You can undo it
Control plus Z
Let's do it again
We want
Is it AM or PM
We can tell
AM or PM
We told
Now It is PM
What happened here? 4 minutes
Here is the second
If you want to do PM
Go back here
And we did here
PM It is wrong
Why is it wrong?
Let's find the solution
Remove it
Control plus Z
See This time is
Like railway time
How is the time in railway?
After 12 o'clock
It is 13
Then 14, 15, 16
Let's correct it
I wrote 16 05 Enter 4 minutes
Is it clear?
How? Time is not like this
After 12 13 14, 15, 16
It is wrong
It is clear
How to
Give AM or PM
Apart from this
You can do one more thing
If you don't want to give
AM or PM
You can select
This format
It will tell you 16.05 Here it is showing you
Seconds If we drag it
It shows us
Hour by hour 4.05 5.05 6.05 7.05 8.05 I hope you understood
Everything This is number
What is number? 1, 2, 3, 4, 5, 6
What is number?
Number is used
When someone is given salary
In salary
A big amount 10,000 20,000 Decimal point
Decimal places
Let's see 9, 8, 7, 6
What did we do?
This format
What did we do?
We made it a number
Dot 0, 0
Automatically What will happen in number?
Decimal points
Decimal places
After this
What we have to do?
We can see number in different ways
Yes, you can
What we will do here?
Suppose My number is in minus
This number is in plus
I will write 2, 3 numbers
I will write here
Minus 9, 8, 7, 6
Below this
Minus 9, 8
I will select these three
What I have to do?
We will go to number
What I have to select?
Number Here Use thousand separator
If there is a value after thousand
Like here
Dot I have to show here
Minus values
Should be in red color
Other values should be in plus
What I can do?
Minus values in red color
I can select this format
What I have done?
Selected What happened here?
Minus value
What happened?
It is in red color
Other values are not in red color
If I select this format
Other values are in red color
You can see
Minus 98
There is no list
There is no formula
This is a random number
When we write a random number
What we do?
When we drag
It will take the same
If I delete all
And select these two
Or select three
Here Here What I have done?
Selected Decimal point
Decimal point
Decrease Decrease Is it clear?
Now let's talk about currency
Currency Currency Currency Currency Currency Currency
Currency Currency Currency Currency Currency Currency I
will do it here 89 rupees so it automatically took 89,
detected and if I add these two how to add? here put equals
to and we saw what is the name of this f5 or f6 so we added
f5 plus f6, how much answer will come? 189 so this also
came in rupees and if you want to see this argument, then
you go here and here see currency and here in
what is there, the currency which is minus you can show
that currency with red you will say here there is no red
currency so here we put the currency minus 90 rupees so
here this minus 90 came so here minus 90 came if we call it
currency and now let's select and see we change the format
go to currency and again we need this format, where there
is minus there comes red, we did ok so now what is this
minus 90 came in red everything is clear and if this is
rupees
You can change currency symbol
Suppose you want dollar of America
Or you want American dollar
You can write in this way So here everything is clear
Then we go to percentage
We have done a video on percentage In that video we have
seen
What was that thing in percentage
We are selecting a number
We are multiplying it
After that what we are doing
After multiplying
We are dividing it
So I give it an interesting
Like I correct the numbers here
I delete them a little
And I do 10, 20
I do numbers like this
So that it is easy for us in percentage
So we selected them
I did it like this
And I delete the decimal
After that
I have to find this format
What I have to do
I have to find
What will be 5%
What will be 5% of 10
So I wrote 5
Now there is no format
What I have to tell this format The percentage format
So I went here and said what is this
What is this percentage 500% Now what I have to do
What I have to do
Like I have to find this number To find this number
What I have to do
You can also change this
Like if you go to percentage
What is your sample
You can also change the decimal places 500% Like in any cell
You wrote equals to
So what you have to do
So we know What is this
And what is this
So what we have done
Multiply We did G5 So we did enter
So what is this
So what is 500% of 10 50 You do not take 500%
So we said 10% What will be 10%
Correct Or We increase the number
We do 100
We did 100
We did 200
We selected all
Now we
Now we subtract 1% What will be 1%
It will be 1 10% What happened
It is taking 1000%
We do not need 1000%
We need 10
We need 10 10% We need 10%
For this you can
You can also put percent symbol
By default
It takes 1000%
Like if I do 20
And I press
Now it is taking nothing
It has become general
So what I do
I remove it from here
And I did format
In percentage
Now I wrote here 20% Now if we select
Both of them
And do like this
It will be 30% 40% 60% 70% I remove the result
And What I did
We need to remove the first one 10% 10% 20% What I did
E5 Multiply E5 Multiply G5 10 What I did
I removed all
Now what I have left
Tax If I select tax format
See what I have to do
Select tax format
Now what my friend told me 0 9
Let's do that thing 0 9 8 7 6
And I did enter
And then I did 0 0 0 0 0
This is also done
This is not done
So what I have to do
I have to give it in tax format
When I did in tax format
Now if I write 0 0
What is this
It is taken in tax format
I understood
What happens many times
Like many times
Phone numbers start
Like 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0