How to insert fractions

This tip describes how to use fractions simply.
To enter a fraction into a cell, leave a space between the whole number and the fraction.

For example, to enter 6 7/8 , 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, 1/8 ), 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.

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.