How to Use Fractions in Microsoft Excel
MS Excel is a spreadsheet program that is part of the Microsoft Office suite of office productivity software. This program assists users in complex analysis and display of various forms of data. Since most of the data you will be using comes in a decimal form, Excel's data display default is decimal form. However, for those situations when you need to list the data in a fractional format, you can change the display options to get the format you need.
Other People Are Reading
Instructions
-
-
1
Open MS Excel. Click on the File menu and then click on the "Open" command. Browse through the folders on your hard drive to find the file with the decimals you need to convert. Click on the file to select it and click on the "Open" button. Let the file open.
-
2
Click in the first cell that needs to converted. Hold the mouse button down and drag the mouse over all the cells that need converting. All the cells should now be highlighted.
-
-
3
Click on the "Format" menu and choose the "Cells" command. Click on the "Number" tab at the top of the screen to display the number options.
-
4
Click on "Fraction" from the list at the left side of the screen. Click on the denomination of fraction you wish to display from the list on the right. Click the "OK" button. The cells will now display their decimals as fractions.
-
1
References
- Photo Credit keyboard image by red2000 from Fotolia.com
