# How to 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.

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