Apple numbers User Manual

    Using Tables 

 

m

To control font attributes, use the text formatting buttons in the Format Bar.

You can also use the Font panel (click Fonts in the toolbar).

m

To check spelling, follow the instructions in “Checking for Spelling Mistakes” on 
page 146.

m

To find and optionally replace text in cells, follow the instructions in “Finding and 
Replacing Text” on page 148.

m

To avoid having Numbers interpret what you type as a number, use the text format. 
See “Using the Text Format” on page 64 for details.

Note:  Text strings are ignored in functions that use values to perform calculations.

Some table operations, such as formulas and functions that perform mathematical 
operations, depend on cells containing numeric values. 

m

In a numeric cell use only numbers (0 through 9) or one of the following characters: +, 
–, (, ), /, $, %, a period, E, or e.

m

You can type some characters (such as %) into a cell, or you can use a cell format, as 
“Formatting Cell Values” on page 58 describes.

m

To specify a negative number, precede it with the minus sign (–).

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.7.77778E+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 Cell” on page 57 for suggestions.

Instructions for using formulas and functions in table cells are in “Using Formulas” on 
page 83 and “Using Functions” on page 96.

Choose a font.

Choose a typeface.

Choose the font size.

Choose the text color.