Numbers as Fractions: How to Show Them

Numbers as Fractions How To Show Them

Getting numbers to appear as fractions in Excel can be difficult.

If you try to insert a fraction into an Excel cell, it’s possible that Excel will convert it to a date or a text string.

Because fractions are not one of the data types that Excel recognizes, this occurs. When you give it a fraction, it attempts to convert it to a date or a text string, which are the only data types that Excel accepts.

So, what if you want your numbers in Excel to be presented as fractions?

In this quick lesson, I’ll teach you how to display integers as fractions in Microsoft Excel using a few different approaches.

Change the cell format to show decimals as fractions / Numbers as Fractions

Fractions are decimal numbers in their purest form.

Example: 1/2 is 0.5, while 1/4 is 0.25

While Excel may not be able to handle fractions by default, decimals are an accepted data format.

Such, with Excel, you can put a decimal value in a cell and style it so that it appears as the required fraction.

Assume I have a data collection with some decimals in column A that I wish to display as fractions.

Excel Decimal Data

The steps to accomplish so are as follows:

Select the cells containing decimals.
Go to the Home tab.

Go To Home Tab In Excel

Click the format drop-down menu in the Number group.

Select “Fraction” from drop down menu

Select Fractions In Drop Down Menu

All of the decimal numbers would be converted to fractions in an instant using the techniques above as per showing in below example.


Thus in few steps we can able to convert decimal numbers into fractions very easily.

I hope you enjoyed this tutorial.

Also Read: How To Calculate Age In Excel Using Formulas 


Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.