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

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 display fraction in cell instead of decimal


You can find similar Excel Questions and Answer hereunder

1) How can I get input from user through a prompt and assign user's input to a cell?

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

3) 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?

4) how do you enter multiple line in a cell in Excel

5) How do I know which cells on the worksheet contain Conditional Formatting?

6) How to find the column number from the cell address in VBA

7) Remove the apostrophe cell text values in Excel

8) How can I enter multiple lines of data in a cell?

9) How can I clear cell after activating a routine when there is a change in value of a cell?

10) How can I get users to select a file for processing using my macro?


Here the previous and next chapter