Display fraction in cell instead of decimal in Excel
For example, when we enter 1/4, Excel normally recognizes it as a date. If we enter =1/4, the display changes to 0.25. Is there anyway I can display a fraction like 1/4 as it is?
To do it in Excel, here is the answer:
a) Enter "0 1/4" to get Excel to display 1/4. Similarly follow the same logic and enter fractions like 3 1/8, 0 1/2, 6 1/7 etc.,
b) As shown below, when entered this way, Excel shows the fraction as it is. Notice that internally the value stored is the same as before - the formula bar would display the actual value stored in the cell.