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.,

excel display fraction in cell instead of decimal

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.

excel excel display fraction in cell instead of decimal


You can find similar Excel Questions and Answer hereunder

1) How can I ensure that user enters only certain acceptable values in an input cell?

2) How can I update a listbox based on data in a list using VBA?

3) How can I remove display of Gridlines in my worksheet using VBA?

4) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

5) Highlight row of selected cell in Excel

6) I want to add a trend indicator symbol next to my sales data - how can I do that?

7) One of my formulas has returned an error - how can I trace the error to fix it?

8) How to read a value from a cell in vba in Excel

9) How can I enter a text in a cell with subscript and superscript?

10) Vlookup to return multiple values in same cell in Excel

11) How can I add and link a Chart Title to a cell value?

12) How can I enter a picture in a cell?

13) How can I avoid updates to cell values during macro execution?

14) How do I enter a formula in a cell using VBA (using Relative Reference)?

15) How can I enter a cent symbol in a cell?