Sometimes in Excel we need to enter values in the form of fractions, but for some reason it is not possible to do this in the usual way. At best, we will get a date.
Therefore, to enter fractions, we need to first format the cell to a fractional format like this:
Then we can enter fractions in the usual way:
You can also enter fractions without pre-formatting the cell. To do this, enter a zero and a space before the fractions:
