Chapter 9 Working with Table Cells 193
You can also use the Font window (click Fonts in the toolbar).
See “Formatting Text Size and Appearance” on page 82 for additional information.
To check spelling, follow the instructions in “ m Checking for Misspelled Words” on
page 118 .
To nd and optionally replace text in cells, follow the instructions in “ m Finding and
Replacing Text” on page 12 0.
To avoid having Pages interpret what you type as a number, use the text format. See m
“Using the Text Format in Table Cells” on page 207 for details.
Note: Text strings are ignored in functions that use values to perform calculations.
Working with Numbers in Table Cells
Some table operations, such as formulas and functions that perform mathematical
operations, depend on cells containing numeric values.
Here are techniques for working with numbers in table cells:
In a numeric cell use only numbers (0 through 9) or one of the following characters: m
plus sign (+), minus sign (–), left or right parenthesis ( ), forward slash (/), currency
symbol (for example, $), percent sign (%), period (.), capital E, or lowercase e.
You can type some characters (such as %) into a cell, or you can use a cell format, as m
“Formatting Table Cell Values for Display” on page 201 describes.
To specify a negative number, precede it with the minus sign (–). m
When you put a number in a table cell that’s too large to display, Pages converts
the number:
When a decimal number doesn’t t in a cell, the number is rounded. For example, Â
1.77777777777777777777 becomes 1.77777777777778.
When a whole number doesn’t t in a cell, the number is displayed using scientic Â
notation. For example, 77777777777777777777 becomes 7.777778E+19.
Scientic notation displays numbers using an exponent raised by the power of 10.
The exponent is displayed following the E.
If the converted number still doesn’t t, it’s clipped. See “Displaying Content Too Large
for Its Table Cell” on page 19 4 for suggestions.
Use formulas and functions in table cells. For more information about this topic,
choose Help > “iWork Formulas and Functions Help” or Help > “iWork Formulas and
Functions User Guide.”
Autolling Table Cells
With autolling you can use the content in one or more cells to automatically add
values to adjacent cells.
Kommentare zu diesen Handbüchern