Convert Fraction to Decimal in Excel (2 Simple Approaches)

When working with numbers and calculations, it is a common thing to get fractions or decimals as results. Sometimes it happens that, the result is shown as a fraction, but we need the result in decimal. At this time, we need to know how to convert fraction numbers to decimals in Excel. This article will show you 2 quick tricks to convert fraction to decimal in Excel.


Download Practice Workbook

You can download and practice from our workbook here.


What Is a Fraction?

A fraction number is a number that is not an integer but expressed as a quotient. The upper part of the quotient is called the Numerator and the lower part of the fraction is called the Denominator.

For example, ΒΌ is a fraction number where 1 is the numerator and 4 is the denominator.


What Is a Decimal Number?

A decimal number is a number that is not an integer but not expressed as a fraction as well. It is a number situated between two integers. And it is comprised of an integer and a decimal part where the decimal part is the fractional value. In addition to these, the decimal number represents that the base of the number is 10. This means there can be 10 unique digits in a number.

For example, 10 and 10.11 are two decimal numbers.

2 Easy Approaches to Convert Fraction to Decimal in Excel

In the following dataset, we have 6 random fraction numbers, which we want to convert to decimal numbers. Follow any of these handy approaches below to convert fractions to decimals.

Convert Fraction to Decimal


1. Use the Format Cells Command to Convert Fraction to Decimal in Excel

You can convert fractions to decimals in Excel by accessing the Format Cells dialog box. You can do this by changing the category of cells in two ways. Follow any of these as per your requirements.

1.1 Converting into General Format

You can convert your fraction number to decimal by changing the category into the General category. Follow the steps below to accomplish this. πŸ‘‡

Steps:

  • At first, copy the fraction numbers and paste them into the cells where you want to convert to decimal. Subsequently, select all the cells and press the right-click button. Consequently, click on the Format Cells… option from the context menu.

Access the Format Cells Dialogue Box

  • Now, the Format Cells window will appear. Now, go to the Number tab. Subsequently, select the General option from the Category list. Consequently, click on the OK button.

Convert Fraction to Decimal Using General Format

Thus, all the fractions will be converted to decimals. But, in this way, you can not choose any formatting for the decimal results. Finally, the result sheet will look like this. πŸ‘‡

Converted Decimals


1.2 Converting into Number Format

Besides, you can convert your fraction number to decimal by changing the category into the Number category. Follow the steps below to accomplish this. πŸ‘‡

Steps:

  • Just like the first method, copy the fraction numbers and paste them into the cells where you want to convert to decimal at first. Subsequently, select all the cells and press the right-click button. Consequently, click on the Format Cells… option from the context menu.

Access the Format Cells Dialogue Box

  • Now, the Format Cells window will appear. Now, go to the Number tab. Subsequently, select the Number option from the Category list. Consequently, click on the OK button.

Convert Fraction to Decimal Using Number Format

  • You can also choose the formatting for the decimal numbers here. You can choose decimal places, negative numbers format, use of thousands separator, etc in this category.

Thus, all the fractions will be converted to decimals. And, in this way, you can choose your desired formatting for the decimal results. Finally, the result sheet will look like this. πŸ‘‡

Converted Decimals

Read More: How to Convert Decimal to Fraction in Excel (4 Smooth Approaches)


2. Use the Number Format Icon

You can convert your fraction number to decimal by using the number format icon. Follow the steps below to accomplish this. πŸ‘‡

Steps:

  • Like the first method, copy the fraction numbers and paste them into the cells where you want to convert to decimal at first. Subsequently, select all the cells and go to the Home tab. Next, go to the Number group. Subsequently, click on the Number Format icon situated at the bottom-right corner of the group.

Access the Number Format Icon to Convert Fraction to Decimal

  • At this time, the Format Cells window will appear. Now, follow step 2 from the 1.1 method or follow steps 2 and 3 from the 1.2 method as per your requirements.

Finally, you will get your fractions converted into decimals.

Read More: How to Make Fractions Smaller in Excel (2 Possible Ways)


Convert Fraction in Text Format to Decimal in Excel

Now, if you gather data from the internet that contains fractions, and the fractions lose their format, rather than appearing in text format; the formulas will help you in converting them to decimal. We will discuss them in two cases.

Case 1: If the Fractions Are Proper

A proper fraction is a fraction where the numerator is less than the denominator. For converting this type of fraction to decimal, follow the steps below. πŸ‘‡

Steps:

  • Select the cell where you want to get your converted decimal result. Say, we want to convert the B6 cell fraction data converted to decimal.
  • Now, put the following formula in the result cell.
=LEFT(B6,SEARCH("/",B6)-1)/MID(B6,SEARCH("/",B6)+1,99)

Subsequently, press the Enter button. And, you can also drag the fill handle downward to copy the formula.

Convert Text Proper Fraction to Decimal

Thus, you can convert fractions to decimals from a text file.


Case 2: If the Fractions Are Mixed

A mixed fraction is a fraction where there is a natural number and a fraction together. For converting this type of fraction to decimal, follow the steps below. πŸ‘‡

Steps:

  • Select the cell where you want to get your converted decimal result. Say, we want to convert the B5 cell mixed fraction data converted to decimal.
  • Now, put the following formula in the result cell.

=IF(ISERROR(SEARCH(" ",B5)),LEFT(B5,SEARCH("/",B5)-1)/MID(B5,SEARCH("/",B5)+1,99),LEFT(B5,SEARCH(" ",B5)-1)+MID(B5,SEARCH(" ",B5)+1,SEARCH("/",B5)-1-SEARCH(" ",B5))/MID(B5,SEARCH("/",B5)+1,99))

Subsequently, press the Enter button. And, you can also drag the fill handle downward to copy the formula.

Convert Text Mixed Fraction to Decimal

Thus, you can convert fractions to decimals from a text file. And, the result will look like this. πŸ‘‡

Convert Text Fraction to Decimal

Read More: How to Write a Fraction in Excel (4 Methods)


Conclusion

So, in this article, I have shown you the 2 easiest tricks to convert fractions to decimals in Excel along with converting fractions from a text file. Use any of these ways to accomplish the result in this regard. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to contact me. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

2 Comments
  1. Sometimes mixed fractions are written with the ASCII 160 (non-breaking space) character instead of the usual ASCII 32 character that Excel recognizes as ” “. If you get a *VALUE! error, you need to use “CHAR(160)” instead of ” ” in the formula, or clean up your text with a find and replace operation before applying the formula.

    • Hi, ERIC!
      Thank you for your valuable feedback.
      You have pointed out a nice thing. When the #VALUE! error happens in this regard, it is better to use the find and replace feature to replace ” ” with CHAR(160) before applying the formula.

      Regards,
      Tanjim Reza

Leave a reply

ExcelDemy
Logo