beautypg.com

Using the fraction format, Using the scientific format – Apple Numbers '08 User Manual

Page 63

background image

Chapter 3

Using Tables

63

Using the Fraction Format

Use the fraction format to control the display of values smaller than 1. For example, 27.5
displays as 27 1/2 when the format is Halves and as 27 4/8 when the format is Eighths.

To define a fractions format, select one or more cells, choose Fractions from the More
Cell Formats pop-up menu in the Format Bar, and choose a format from the submenu.

You can also use the Cells Inspector.

To define a fraction format for selected cells using the Cells Inspector:

1

Select the cell or cells.

2

Click Inspector in the toolbar, and then click the Cells Inspector button.

3

Choose Fraction from the Cell Format pop-up menu.

4

Choose a display format from the Accuracy pop-up menu.

Using the Scientific Format

Use the scientific format to display numbers using an exponent raised by the power of
10. The exponent is displayed following an “E.” For example, the value 5.00 in scientific
format displays as 5.00E0. And the value 12345 displays as 1.2345E4.

More Cell
Formats button