Fraction Number in Excel

We all deal with numbers in Excel. We make some formatting to numbers in Excel to look better and readable. But, especially when we work with decimal numbers, we usually maintain two decimal points to read the numbers correctly.

For example, if we want to show 1.5 in the cell, we need to maintain one decimal point to read that as 1.5. Else, it may show as 2.

Well, we all know this technique early on in Excel learning. For example, if we recollect the mathematics class in the school, the math teacher has taught us about fractions.

There is an alternative method to write decimal numbers in the form of fractions. For example, instead of writing 0.5, we can write ½. Rather than 0.25, we can write ¼, 0.75 as ¾. We can also apply this technique to Excel.

We cannot see this kind of several formatting techniques in excelFormatting Techniques In ExcelFormatting is a useful feature in Excel that allows you to change the appearance of the data in a worksheet. Formatting can be done in a variety of ways. For example, we can use the styles and format tab on the home tab to change the font of a cell or a table.read more quite often. But, instead of showing the number as 1.5, we can display it as 1 ½.

We can see these numbers, usually in stock market share prices. So, for example, in the equity market industry, we might hear people talking in a fraction like “Company A acquired ¼ (one-fourth)of the shares, Company C sold its 2/3 (two-thirds of) of shares to another company.

Since we do not regularly see these kinds of fraction numbers in Excel, we present this article on fraction numbers in Excel. Therefore, go through this article and learn about fraction numbers in Excel.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Fractions in Excel (wallstreetmojo.com)

How to Format Numbers as Fractions in Excel?

In Excel, we can format the numbers as fractions in several ways. For example, we can format numbers as fractions in two ways: using the “Number” format under the “Home” tab and using the “Format Cells” option.

Method #1 – Format by Using Home Tab

We have a few numbers from cell A1 to A10 with decimal points. Let us convert them into fractions using the “Home” tab.

We must select all the numbers from A1 to A10.

Go to the “Home” tab. Then, under the “Number” option, click on the drop-down of the “Number” format.

Select the “Fraction” option from this drop-down list.

Now, it will convert all the decimal numbers to fractions.

Method #2 – Format by Using Format Cell Option

Take the same numbers from the previous example, where we have data from cells A1 to A10 with decimal points. Let us convert them into fractions using the “Format Cells” option.

How to use Fraction Numbers in Excel?

Now, we will look at using fraction numbers practically. Finally, we will prepare a list of ingredients required for Biryani preparation. Below are the necessary ingredients for Biryani.

  • We must select the cells from A1:A10. Then, right-click on cells and select “Format Cells.” Instead of right-clicking and selecting the “Format Cells,” we can press the shortcut key “Ctrl +1.” It may show the below window.Under this window, select “Fraction.” Here, under this, we can see all kinds of fraction options. We will choose the first option.Click on “OK” to complete the procedure. Now, we may see fraction numbers instead of decimal numbers.

Instead of right-clicking and selecting the “Format Cells,” we can press the shortcut key “Ctrl +1.” It may show the below window.Under this window, select “Fraction.” Here, under this, we can see all kinds of fraction options. We will choose the first option.Click on “OK” to complete the procedure. Now, we may see fraction numbers instead of decimal numbers.

Let us create a template in an Excel sheet.

Now, we have quantity in column C. In kitchen terminology, decimal numbers are usual things. So we need to show them in a fraction.

We must apply any one of the above two methods.

Now, it is actually in kitchen terminology.

Things to Remember

  • We can create a fraction of up to three digits.We can see an actual decimal number in the “Formula” bar.If we multiply 1/4 with 2, the result will be ½.We can show fractions in two ways: 4s as ¼, 2/4, ¾, and 8s as 2/8, 4/8, and 6/8.

This article is a guide to the Fraction Number in Excel. We discuss formatting fractions in Excel using the “Home” tab and “Format Cells” option with practical uses of fractions in Excel. You may also look at these useful functions in Excel: –

  • Formatting Numbers to Millions in ExcelDivide in ExcelCalculate Percentage in ExcelSubtraction Formula in ExcelS Curve in Excel