Let’s talk about “Fraction” in Excel
What is a fraction?
Where excel fraction is used?
How to use it with an example
Where excel fraction is used?
It is a part of the whole number and is represented as numerator and denominator i.e.a/b
Where excel fraction is used?
How to use it in excel with an example
Oh hurray, weekend!!!
I have just planned to cook something today and started searching for a few recipes around the internet.
Biryani was an exciting option to choose and I did.
The recipe was something like below
1/2 Kg – Chicken
1 1/4 tbsp – Ginger garlic paste
1/2 tbsp – Salt
1 tbsp – Lemon juice and so on…
Liking the recipe, I have thought of storing it somewhere.
Excel is the best to do that so started with recording the data into it.
Excel steps here…..
4 Steps To Use Fraction Number Format In Excel
Step 1:Â Select the range that you want to be formatted
Step 2:Â Now select “Number Format” option and then “More number formats” option at the bottom.
Step 3:Â Now select the “Fraction” option and then your desired format.
Here I have selected “Up to one digit” type.
Step 4:Â Now click “OK” and start entering the data and we are done.
@Checkout the example below
With many other options available such as
Up to one digit(1/2), up to two digit(21/34), up to three digit(43/123), fractions as halves(1/2) and so on…
Attention: If no fraction is applied to the cell, then 1/2 will be considered a date.
Hope the article has helped you…