Have you ever tried to enter a fraction into your Excel sheet, however once you press enter, it turns right into a serial, complete, or decimal quantity, and you don’t have any clue what to do? In Microsoft Excel, you may convert a quantity right into a fraction utilizing the Fraction format.
What’s a Fraction format in Excel?
In Math, a fraction definition is a numerical amount that isn’t a complete quantity, however in Excel, fractions are a quantity format used to display the numbers as fractions as a substitute of numbers. The formatting of Excel capabilities comes with a number of choices, such as up to one digit, two digits, three digits, halves, quarters, eighths, sixteenths, and so forth.
How to display Numbers as Fractions in Excel
Comply with the steps under to display numbers as fractions in Microsoft Excel.
- Choose the cell you need to format
- Click on the dialog field launcher subsequent to Quantity on the Dwelling tab
- Within the Class listing on the left pane, click on Fraction
- Within the Sort listing on the correct, click on the fraction format sort you need to see.
- Then click on OK
Launch Excel.
Sort a decimal or a complete quantity into the cell.
Click on the dialog field launcher subsequent to Quantity on the Dwelling tab
A Format cells dialog field will open.
Within the Class listing on the left pane, click on Fraction.
Within the Sort listing on the correct, click on the fraction format sort you need to see, particularly:
The preview of the fraction format will display in the Pattern field.
Then click on OK.
see the end result above.
There are two different strategies in Excel that convert a quantity right into a fraction.
Methodology 1, On the Dwelling tab, click on the Quantity Format button and choose the Fraction choice.
If you need to change the fraction format, click on Extra Quantity codecs to display the Format cells dialog field.
Methodology 2 is to right-click the cell and choose Format cell.
The Format cell field will open.
Click on Fraction from the class listing, then select a fraction format.
Then click on OK.
Associated: Repair The file is corrupt and can’t be opened error in Phrase, Excel, PowerPoint.
We hope this tutorial helps you perceive how to display numbers as fractions in Excel; when you’ve got questions concerning the tutorial, tell us in the feedback.
What’s the shortcut key to sort Fractions in Excel?
In Microsoft Excel, you should use the next shortcut keys to insert a fraction:
- Choose the cell the place you need to insert the fraction.
- Press Alt + 0185 (on the numeric keypad) to insert the fraction 1/4.
- Press Alt + 0178 (on the numeric keypad) to insert the fraction 1/2.
- Press Alt + 0179 (on the numeric keypad) to insert the fraction 3/4.
Other than these, it’s greatest to use the Format cells choice for the remainder of the fraction sort, however if you need one thing fast, you should use these keyboard shortcuts.
