beautypg.com

Using the text format in table cells, 99 f – Apple Numbers '09 User Manual

Page 99

background image

Chapter 4

Working with Table Cells

99

For more control over the number of decimal places, use the Cells inspector.

To define a scientific format for one or more 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 Scientific from the Cell Format pop-up menu.

4

Use the Decimals field to specify the number of decimal places to display.

Using the Text Format in Table Cells

Use the text format when you want all of a cell’s content to be treated as text, even
when it’s a number. When a text format is applied to a cell, its value is displayed exactly
as you type it.

Here are ways to define a text format for one or more selected cells:
Click the Cell Formats button in the format bar and then choose Text.

m

Click Inspector in the toolbar, click the Cells inspector button, and then choose Text

m

from the Cell Format pop-up menu.

Using a Checkbox, Slider, Stepper, or Pop-Up Menu in Table Cells

You can add a checkbox, slider, stepper, or pop-up menu to a cell:
Checkbox: Useful for cells whose value indicates one of two states, such as on or off,
or yes or no.
Slider: Useful for quickly making large changes to numbers so you can see the effects
of the changes on other cells in the table or on a chart.
Stepper: Use to increase or decrease numbers in specific increments.
Pop-up menu: Use to predefine the values a cell can contain.

When a cell is formatted to use a checkbox or pop-up menu, you can add or change a
cell’s content only by using the control. Cells that use a slider or stepper let you type a
value into the cell or use the control.

Here are ways to add controls to cells:
To add a checkbox, select the cell or cells.

m