How to insert fractions
To enter a fraction into a cell, leave a space between the whole number and the fraction.
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.
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.
