How to display fractions with MS exel 2002

By Tweek45

(MicroSoft Excel)

Rate: (3 Ratings)

How to display fractions with Excel

Flag Article

Instructions

Difficulty: Moderately Easy

Step1

Start Excel.

Step2

Before you type fractions in cells, pre-format the group of cells that need to be displayed as fractions. Select the cells where you want to enter fractions, and then on the Format menu, click Cells.

Step3

In the Category list, click Fraction and then, from the list on the right, select the type of fraction that you would like to display. Click OK.

Step4

To type fractions in these preformatted cells, type the numerator, then a slash "/", then the denominator. Do not type space

Tips & Warnings

For example, type "1/2" to represent one-half. If you type "4/8" to represent one-half, Office Excel will reduce it to 1/2. Excel reduces all fractions to their lowest terms.
If you need to type a whole number and a fraction in the same cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator), for example, "2 4/9".