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.
The steps to accomplish so are as follows:
Select the cells containing decimals.
Go to the Home tab.
Click the format drop-down menu in the Number group.
Select “Fraction” from 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
