Hello all, Today we will discuss Fraction Formatting in Excel Sheet, chances are you might have used Fractional values in decimal format while using Excel Sheet for Calculations, but to your surprise, we can also use the fractional values in Fractional Format, just as we write physically on papers.Let’s Learn the trick, How can we do that on Excel Sheet.
Fractional Formatting is another Category of representing numbers in Excel Sheet, and we do this by formatting cells in Excel.We can apply Fractional Formatting in a single cell, complete row, complete column, whole Excel Sheet, a range of cells, alternative rows or columns etc.Excel provides various Fraction Formats to use, like Single digit Fraction, double digit, Fraction as halves, as quarters etc.
Fractional Formatting Types in Excel:
- Single digit Fraction-This Format round off the fractional value in nearest single digit Fractional value.
- Double digit Fraction-This Format round off the fractional value in nearest double-digit Fractional value.
- Triple digit Fraction-This Format round off the fractional value in nearest Triple digit Fractional value.
- Fraction as halves
- Fraction as quarters
- Fraction as eighths or sixteenths
- Fraction as tenths or hundredths
Now, Let’s learn the Fractional Formatting through an example,Suppose you need to prepare an Excel Sheet for making chocolate chip cookies, then your Excel Sheet would look something like this,
Suppose you need to prepare an Excel Sheet for making chocolate chip cookies having ingredients as Salt,Flour,Butter,Eggs,Vanilla,Baking powder and chocolate chips and specified Measurement equipment’s like teaspoon or cup to maintain the accurate amount of Ingredients to be added, then your Excel Sheet would look something like this,
Now, you want to specify the amount of Ingredients to be added, and for precisional values, you need to specify amount in Fractional Format, then you would follow these steps,
- You would select the entire Amount Column by pressing CTRL+SHIFT+ARROW KEY(either up or down) or you can click on Column Heading “Amount” and drag your mouse till the Chocolate Chips.
- Now, you need to right-click any selected cell and select “Format Cells” or press CTRL+1.
- Change the Number Formatting to Fraction Formatting, by selecting “Fraction” from the list.
4. In the “Type” list, you can select the Fraction Format you want to use, like the Single Digit, Double Digit, Up to three digits etc.
5. Now, Enter your Fraction in the Formatted cell “Amount”, like this,
Note that we can also use Mixed Fractions here, Excel would treat those values like the decimal number only, which you can see in Formula bar.
The Best part is we can use Fractions in Formulas and Functions as well like we need to calculate Total of the “Amount” cell then we just need to use SUM Function “=SUM(range)” , like for this example “=SUM(B2: B8)” and it would return answer in Fractional Format.
This is how you can use Fractional Formatting in Excel Sheet easily.Share it if you find it helpful and help your friends and colleagues also who are new to Excel.Practice more to learn things better.Write your queries to us anytime, we are here to help you.