display fraction in cell instead of decimal in Excel
Q110. In Excel, how can I display fractions as it is in a cell (instead of displaying as a decimal)?
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.