Fractions

EasySpreadsheet can quickly convert decimal numbers in your sheet to fractions. For example, if 0.5 was formatted as a fraction, it would be displayed as 1/2.

To display numbers as fractions:

  1. Select the cell(s) that you want to format.

  2. Go to the Format menu, and click Cells.

  3. A Format Cells window will appear.

  4. Click the Number tab.

  5. In the Category box, click Fraction.

  6. A list of fraction format types will appear in the Type box. Click on a type to select it. When you click on a type, a Sample will be displayed below.  

  7. After selecting a type, click OK.

  8. The fraction formatting will be applied to the selected cell(s). Note that the numbers will still be numerical values after the formatting is applied.

Note: To quickly access the number formatting window, go to the Format menu, and click Number formatting.

 

Fractions in Formulas

Users experienced in entering formulas may prefer to use fractions while typing in a cell.

  1. Click on the cell you want the insert the fraction value into.

  2. Type the number in the cell. Use a backslash (/) to indicate that you have entered a fraction value. For example, type 3 1/2.

  3. Press Enter.

  4. In the cell, the number will appear as a fraction. The standard, decimal number will appear in the formula bar above the spreadsheet. For example, if you enter 3 1/2, then 3 1/2 will appear in the cell, and 3.5 will appear in the formula bar.

Examples:

Fraction

Standard Number

1/2

0.5

2/3

0.666666666666667

1

1

4 1/4

4.25