How to insert fractions

Excel 2016 2013 2010 2007 2003
Fractions represent equal parts of a whole object or a collection of items. This tip describes how to use fractions simply. For example:
  • I paid the third part, that is, I paid 1/3 of the transaction,
  • Five of our group of 17 wore yellow dresses, which means 5/17 of our group were in yellow,
  • The guy ate 8 pies and 2/3 - he didn't have enough strength for more; i.e., he ate 8 2/3 pies.

The fraction consists of two parts:

  • The number at the top of a line (or before a slash like 1/2) is called the numerator. It tells how many equal parts of the whole or collection are taken.
  • The number below the line (or after the slash) is called the denominator. It shows the total divisible number of equal parts of the whole or the total number of equal parts in the collection.

The simplest way to enter a fraction

To enter a fraction into an Excel cell, leave a space between the whole number and the fraction.

For example, for entering 5 2/7 fraction in Excel 365, type 5 2/7, and then press Enter.

When you select the cell, 6.875 appears in the Formula bar, and the cell entry appears as a fraction:

Fraction 5 2/7 in Excel 365

If you have a fraction only (for example, 2/7 fraction in Excel 365), you must enter a zero first, like this: 0 2/7 - 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.28571428571429, and in the cell, you see 2⁄7:

Fraction 2/7 in Excel 365

Format a cell as a fraction

You can format a cell as a fraction by doing the following:

   1.   Select a cell or a range of cells you want to format.

   2.   Do one of the following:

  • To use the Fraction format used by default, on the Home tab, in the Number group, open the Number Format dropdown list:
    Number Format dropdown list in Excel 365

    From the Number Formats dropdown list, choose Fraction:

    Fraction in Number Formats Excel 365
  • Right-click on the selection and choose Format Cells... in the popup menu:
    Format cells in popup menu Excel 365
  • On the Home tab, in the Number group, click the dialog box launcher:
    Format cells in Excel 365
  • Press Ctrl+1.

In the Format Cells dialog box:

  • On the Category list, select Fraction,
  • From the Type list, select one of the nine fraction types:
Cells formats in Excel 365
Type Description Formatted value 5 123/789
Up to one digit (1/4) Rounds to the nearest single-digit fraction value 5 1/6
Up to two digits (21/25) Rounds to the nearest double-digit fraction value 5 12/77
Up to three digits (312/943) Rounds to the nearest triple-digit fraction value 5 41/263
As halves (1/2) Rounds to the nearest half 5
As quarters (2/4) Rounds to the nearest quarter 5 1/4
As eighths (4/8) Displays the value in eighths 5 1/8
As sixteenths (8/16) Displays the value in sixteenths 5  2/16
As tenths (3/10) Round to the nearest tenth 5 2/10
As hundredths (30/100) Rounds to the nearest hundredth 5 16/100

Note: You can use a custom format string to create other fractional formats.

For example:

Description Custom format Formatted value 5 123/789
In 50ths # ??/50 5  8/50
Without a leading value ?/? 31/6
In sixteenths with inches sign # ??/16\” 5  2/16”

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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more