How to insert fractions
For example, to enter , enter 6 7/8 , and then press Enter .
When you select the cell, 6.875 appears in the Formula bar, and the cell entry appears as a fraction.
If you have a fraction only (for example, ), you must enter a zero first, like this: 0 1/8 - otherwise Excel will likely assume that you are entering a date. When you select the cell and look at the Formula bar, you see 0.125 . In the cell, you see 1⁄8 .