Cart 0

Working with Fractions in Excel

Posted by Roger Hyttinen on


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
    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.



Share this post

← Older Post Newer Post →