Press Alt + 0178 (on the numeric keypad) to insert the fraction 1/2.

Press Alt + 0185 (on the numeric keypad) to insert the fraction 1/4.

Select the cell where you want to insert the fraction.In Microsoft Excel, you can use the following shortcut keys to insert a fraction: What is the shortcut key to type Fractions in Excel? We hope this tutorial helps you understand how to display numbers as fractions in Excel if you have questions about the tutorial, let us know in the comments. Related: Fix The file is corrupt and cannot be opened error in Word, Excel, PowerPoint. Method 2 is to right-click the cell and select Format cell.Ĭlick Fraction from the category list, then choose a fraction format. If you want to change the fraction format, click More Number formats to display the Format cells dialog box. Method 1, On the Home tab, click the Number Format button and select the Fraction option. There are two other methods in Excel that convert a number into a fraction. The preview of the fraction format will display in the Sample box. In the Type list on the right, click the fraction format type you want to see, namely: In the Category list on the left pane, click Fraction. Type a decimal or a whole number into the cell.Ĭlick the dialog box launcher next to Number on the Home tab In the Type list on the right, click the fraction format type you want to see.In the Category list on the left pane, click Fraction.Click the dialog box launcher next to Number on the Home tab.How to display Numbers as Fractions in Excelįollow the steps below to display numbers as fractions in Microsoft Excel.

The formatting of Excel functions comes with several options, such as up to one digit, two digits, three digits, halves, quarters, eighths, sixteenths, etc.

In Math, a fraction definition is a numerical quantity that is not a whole number, but in Excel, fractions are a number format used to display the numbers as fractions instead of numbers. Have you tried to enter a fraction into your Excel sheet, but when you press enter, it turns into a serial, whole, or decimal number, and you have no clue what to do? In Microsoft Excel, you can convert a number into a fraction using the Fraction format.

Dialog box launcher excel