Table of Contents
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.