Working with Fractions in Excel

You can format numbers in Excel so that they display fractions in old-school format, such as 3/4 or 1/2 from the Format Cells dialog box. Excel also supports compound fractions such as 4 1/2.

Format Numbers a Fractions

1. Select the cells you want to format.
2. Right-click the selected cells and choose choose Format > Cells from the menu
   Or
   Click the dialog launcher on the Number group of the Ribbon.
   
3. Click the Fractions category in the left pane.
4. Choose the fraction format you want from the Type: window.

You can also apply the Fraction format automatically as you enter in numbers. For compound fractions, type the whole number, tap your spacebar and then the fraction, such as 8 1/2. If the fraction is less than 0, type a 0, followed by a space and then the fraction, such as 0 3/4.