Apple Numbers '09 - Manual (Page 80)

To control font attributes, use the text formatting buttons in the format bar. m
Choose a font.
Choose a typeface.
Choose the font size.
Choose the text color.
You can also use the Fonts window (click Fonts in the toolbar).
See “Formatting Text Size and Appearance” on page 165 for additional information.
To check spelling, follow the instructions in “
m Checking for Misspelled Words” on
page 190.
To find and optionally replace text in cells, follow the instructions in “
m Searching for and
Replacing Text” on page 192.
To avoid having Numbers interpret what you type as a number, use the text format.
m
See “Using the Text Format in Table Cells” on page 99 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 89 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, Numbers converts
the number:
When a decimal number doesn’t fit in a cell, the number is rounded. For example, Â
1.77777777777777777777 becomes 1.77777777777778.
When a whole number doesn’t fit in a cell, the number is displayed using scientific
Â
notation. For example, 77777777777777777777 becomes 7.777778E+19.
Scientific 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 fit, it’s clipped. See “Displaying Content Too Large
for Its Table Cell” on page 82 for suggestions.
80 Chapter 4 Working with Table Cells