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 tips for working with numbers in table cells:
In a numeric cell use only numerals (0 through 9) or one of the following characters:
plus sign (+), minus sign (–), left or right parenthesis ( ), forward slash (/), currency
symbol (for example, $), percent sign (%), period (.), capital E, or lowercase e.
You can apply cell formatting for numbers, as described in “
Formatting Table Cell
Values for Display” on page 178.
To specify a negative number, precede it with the minus sign (–).
When you enter a number that's too large to display in a table cell, Keynote converts
the it to a different numerical format:
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 “Resizing Table Rows and
Columns” on page 162 for suggestions.