How to Use Excel to Convert Decimals to Fractions
If you stick with default settings, you are unlikely to ever see a fraction in Microsoft Excel. However, Excel offers many selectable number formats, such as currency, percentages and even fractions. By selecting fractions as the format, you can use Microsoft Excel to easily convert decimals into fractions. You can even select the precision of the displayed fraction, such as single or even triple-digit fractions.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Excel.
-
2
Enter a decimal number into any cell, such as A1.
-
-
3
Right-click the cell which contains the decimal number and select "Format Cells."
-
4
Click the "Number" tab of the "Format Cells" window.
-
5
Click "Fraction" in the "Category" list of the "Number" tab.
-
6
Select the format type in the "Type" section, such as "Up to one digit" or "Up to three digits," and press "OK" to convert the decimal into a fraction.
-
1
