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
- Select the cells you want to format.
- 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. - Click the Fractions category in the left pane.
- 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
- Tags: Excel, Microsoft Office Tips