How to insert fractions

Excel 365 2016 2013 2010 2007
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.

See also this tip in French: Comment insérer des fractions.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.