Excel displays dates instead of fractions
Another problem you may face when working with fractions in Excel is that Excel displays dates instead of fractions in cells. For example, if you enter the value 1/2 in a cell without using quotation marks or zeros, Excel displays 02-Jan in that cell.
This occurs because Excel by default considers numeric values with numeral/denominator format without quotation marks or zeros as dates. If the numerator is a number between 1 and 12, then Excel will consider it a month. If the denominator is a number between 1 and 31, then Excel considers it a day. If the denominator is greater than 31, then Excel considers it a year.
To work around this issue, you must enter fractional values by using quotation marks or zeros, as described earlier. That way, Excel recognizes fractional values as fractions instead of dates.
Conclusion
Converting numbers to fractions in Excel is a simple task, but it can have a big impact on how you present your data. By following the steps we gave above, you will be able to easily convert numbers to fractions as per your need.
Excel is a powerful tool, and an understanding of how to use it well can improve your productivity and ability to manage data. Hope this article has helped you in carrying out your daily tasks more efficiently.