Table of Contents
Converting a decimal to a fraction in Excel can be done using the “Format Cells” option. First, select the cell containing the decimal number. Then, go to the “Number” tab in the “Format Cells” dialog box and choose “Fraction” under the “Category” section. This will convert the decimal to a fraction format. Alternatively, the decimal can be manually converted to a fraction by dividing the number by 1 and formatting the cell as a fraction. This method can be useful for precise fraction conversions.
Convert a Decimal to a Fraction in Excel
You can use the following formula to convert a fraction to a decimal in Excel:
=TEXT(A2,"#???/???")
This particular formula will convert the decimal in cell A2 to a fraction.
For example, if cell A2 contains 0.2 then this formula will return 1/5.
The following example shows how to use this formula in practice.
Related:
Example: How to Convert Decimal to Fraction in Excel
Suppose we have the following list of decimals in Excel:
Suppose we would like to display each decimal in column A as a fraction in column B.
To do so, we can type the following formula into cell B2:
=TEXT(A2,"#???/???")
We can then drag and fill this formula down to each remaining cell in column B:
Column B now displays each decimal in column A as a fraction.
For example:
- 0.2 as a fraction is 1/5.
- 0.25 as a fraction is 1/4.
- 0.26 as a fraction is 13/50.
- 0.333 as a fraction is 1/3.
Note that when you have a number greater than one, this formula will return an improper fraction (a fraction where the numerator is greater than the denominator) as a result.
For example, the last value in the decimal column is 1.4.
This formula returns 7/5, which represents 1.4 as an improper fraction.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: