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:


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:


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

Leave a Reply

Your email address will not be published. Required fields are marked *