Apple Keynote '09 - Manual (Page 182)

If a value contains more decimal places than you specify, the decimal value displayed
is rounded, not truncated. For example, if a cell is formatted to display two decimal
places, the value 3.456 is displayed as 3.46, not 3.45.
6 To specify how to display negative values, choose an entry from the pop-up menu
adjacent to the Decimals field.
7 To specify whether to use a thousands separator, select or deselect Thousands Separator.
If a cell you’re formatting already contains a value, the value is assumed to be a
decimal value, and it’s converted into a percentage. For example, 3 becomes 300%.
To learn about the suite of functions and formulas available in iWork, and how to use
them, see the iWork Formulas and Functions User Guide or help (choose Help > “iWork
Formulas and Functions Help” or “iWork Formulas and Functions User Guide”).
Applying a Date and Time Format to Table Cells
Use the date and time format to display date and/or time values.
To define a date and time format using the Cells inspector:
1 Select the cell or cells.
2 Click Inspector in the toolbar, and then click the Table button.
3 In the Table inspector, click Format.
4 Choose “Date and Time” from the Cell Format pop-up menu.
5 To specify how you want a date formatted, choose a format from the Date pop-up menu.
6 To specify how you want a time value formatted, choose a format from the Time pop-
up menu.
Applying a Duration Format to Table Cells
Use the duration format for values that describe time increments, such as weeks, days,
hours, minutes, seconds, or milliseconds.
To apply a duration format:
1 Select the cell or cells.
2 Click Inspector in the toolbar, and then click the Table button.
3 In the Table inspector, click Format.
4 Choose Duration from the Cell Format pop-up menu.
5 Use the Units control to select the units you want to display for a duration value.
By default, hours, minutes, and seconds (h, m, and s) are displayed.
To choose a single unit, drag the left or right end of the slider toward the center until it
can get no shorter. Then click in the center of the slider and drag it over the unit you
want to use.
182 Chapter 10 Using Tables