How to use fraction numbers
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.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/how to use fraction numbers.html