In Excel by default the fractional values are displayed in decimals, fractions in excel are number formats where the fractions are displayed as the actual fractions rather than the decimals, they can be accessed from the format tab of the excel and then from the category list we can choose fraction and now our numbers will be in fraction format not in decimal format.
Fraction Number in Excel
We all deal with numbers in excel, we make some formatting to numbers in excel to look better and readable. Especially when we work with decimal numbers we usually maintain two decimal points to read the number correctly.
For example, if you want to show 1.5 in the cell we need to maintain at least one decimal point to read that as 1.5 or else it will show as 2.
Well, we all know this technique early on in the excel learnings. If you recollect your mathematics class in your school your math teacher must have taught about fractions.
There is an alternative method to write decimal numbers in fractions. For example, instead of writing 0.5 we can write ½, instead of writing 0.25 we can write ¼, we can write 0.75 as ¾. Yes, we apply this technique to excel as well.
We do not see this kind of numbers of formatting techniques in excel quite often. But instead of showing the number as 1.5 we can show as 1 ½.
We could be able to see these kinds of numbers usually in stock market share prices. In equity market industry you must hear people taking in a fraction like “Co., A acquired ¼ (one fourth)of shares, Co., C sold its 2/3 (two third of) of shares to other company.
Because we do not get to see these kinds of fraction numbers regularly in excel we are presenting this article on Fraction numbers in Excel. Go through this entire article and learn about fraction numbers in excel.
How to Format Numbers as Fractions in Excel?
In excel we can format the numbers as fractions in a couple of ways. We can format numbers as fractions in two ways one is by using Number format under the Home tab and the second one is using the Format Cell option.
Method #1 – Format by Using Home Tab
I have few numbers from cell A1 to A10 with decimal points. Let’s convert them into fractions using the Home tab.
Select all the numbers from A1 to A10.
Go to Home tab and under Number click on the drop-down of Number Format.
Select Fraction option from this drop-down list.
Now it will convert all the decimal number to fractions.
Method #2 – Format by Using Format Cell Option
Take the same numbers from the previous example where I have data from cell A1 to A10 with decimal points. Let’s convert them into a fraction by using the Format Cell option.
Step 1: Select the cells from A1:A10
Step 2: Right-click on cells and select Format Cells.
Step 2.1: Instead of right click and select Format Cells you can press the shortcut key Ctrl +1. You will see below the window.
Under this window select Fraction. Here we will see all kinds of fraction options under this. Select the first one.
Click on ok to complete the procedure. Now we will see fraction numbers instead of decimal numbers.
How to use Fraction Numbers in Excel?
Now we will look at using fraction numbers practically. We will prepare a list of ingredients required for Biriyani preparation. Below are the ingredients required for Biriyani.
Let us create a template in excel sheet.
Now we have quantity in the column C. In kitchen terminology decimal numbers usual thing. We need to show then in a fraction.
Apply any one of the above 2 methods.
Now it is actually in kitchen terminology.
Things to Remember
- We can create a fraction up to 3 digits.
- We can ofsee an actual decimal number in Formula bar.
- If you multiply 1/4 with 2 the result will be ½.
- We can show fractions in two ways one as 4’s i.e. ¼, 2/4, ¾, and another one as 8’s i.e. 2/8, 4/8, 6/8.
This has been a guide to Fraction Number in Excel. Here we discuss how to format Fractions in Excel using Home Tab and Format Cell Option along with practical uses of fractions in excel. You may also look at these useful functions in excel –