How to Display Numbers as Fractions in Excel 2010

Microsoft Excel 2010 provides a vast assortment of tools and features that will help you to manage data in your spreadsheets. By default, the numbers that you enter into your cells will be displayed as decimals, but Excel has the capabilities to display these numbers as fractions instead.

Our short guide below will show you how to select the cells that you wish to display as fractions, then change the formatting of those selected cells so that they are displayed as fractions.


Switch from Decimals to Fractions in Excel 2010

The steps below will show you how to change the format of the cells that you select. Numbers entered into cells that are not selected will still be displayed as decimals by default.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Select the cells that you wish to switch to fractions. You can select all of the cells in a worksheet by clicking the button between the letter A and the number 1 at the top-left corner of the spreadsheet.

select the cells to switch to fractions



Step 3: Click the Home tab at the top of the window.

click the home tab



Step 4: Click the Format Cells: Number button at the bottom-right corner of the Number section in the navigational ribbon.

click the number dialog button



Step 5: Click Fraction in the column at the left side of the window, then click the type of fractions that you would like to use from the list at the right side of the window under Type.

select fractions



Step 6: Click the OK button at the bottom of the window to apply the new formatting to your selected cells.

click ok



Are you printing a lot of spreadsheets in Excel 2010, but find that they aren’t printing well? Read our guide to printing in Excel for some simple tips that will simplify the process of printing your spreadsheets. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.