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:** How to Convert a Fraction to a Decimal in Excel

**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.**

And so on.

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:

Excel: How to Convert Time Duration to Minutes

Excel: How to Convert Percentage to Ratio

Excel: How to Convert UNIX Timestamp to Date