How to Remove Fractions in Excel

1. Launch Microsoft Excel 2010 and open the spreadsheet that contains or will contain the numbers that need to be displayed without fractions.
2. Click a cell or highlight (Select) a range of cells by clicking on one cell and holding the mouse button down while dragging the cursor across a range of cells. Release the mouse button to select the highlighted range. You can also click directly on a column letter or row number to select the entire column or row. Add or remove from the current selection by holding down the 'CTRL' key while selecting the cells you do not want changed.
3. Right-click any of the selected cells and click 'Format Cells' from the context menu.
4. Click the 'Number' tab in the 'Format Cells' dialog box.
5. Click the desired format for the display and storage of the numbers in the selected cells. Make preference adjustments on the right side of the dialog box using the instructions at the bottom of the dialog box. The 'Sample' box will display a preview of the format for any data in the selected cell.