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

Tables in Keynote are equipped to perform mathematical calculations in conjunction with the suite of functions and formulas built into iWork. For detailed information about how to use the hundreds of iWork functions, choose Help > iWork Formulas and Help, or go to Formulas and Functions Help on the web.

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.

  • 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 for suggestions.

Was this page helpful? Send feedback.