How to Display Fractions in Excel 2003

1. Open Excel by going to the 'Start' menu, pointing to 'Programs' or 'All Programs', and clicking on 'Microsoft Excel' in the 'Programs' list. Or you can open Excel by double-clicking a shortcut icon on your desktop or task bar.
2. Open a blank or existing worksheet. Select the cells you will want to use to enter fractions by clicking on one of the outer cells in that range, holding down the left mouse button and dragging your mouse across the range of cells that you want to select. If you only want to format a single cell, simply click on that cell.
3. Click on 'Format' in the toolbar. Click 'Cells'. The 'Format Cellsw' dialog box will open. Make sure you are on the 'Number' tab.
4. Click 'Fraction' in the 'Category' list. Under 'Type', choose how you want your fractions displayed. You can choose up to one, up to two or up to three digits, or take it even further and choose 'As Halves', 'As Quarters' and so forth, which will round your fraction the the nearest, half, quarter or whatever you choose.
5. Click 'OK'. When you enter your data into the cells you formatted, your fractions will now appear just as you defined.