# How to insert fractions

- 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. It tells how many equal parts of the whole or collection are taken.*numerator* - The number below the line (or after the slash) is called the
. It shows the total divisible number of equal parts of the whole or the total number of equal parts in the collection.*denominator*

## 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 , 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:

If you have a fraction only (for example, ), 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*:

## 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:From the

**Number Formats**dropdown list, choose**Fraction**: - Right-click on the selection and choose
**Format Cells...**in the popup menu: - On the
**Home**tab, in the**Number**group, click the dialog box launcher: - 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:

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.