Apple Keynote '09 - Manual (Page 180)

This content in a cell assigned the automatic
format Is formatted like this for display
A number Decimal places and commas are preserved
as entered.
For example, 1,000,000.008 displays as
1,000,000.008.
A currency value Decimal places and commas are preserved as
entered. For example $1,000.0075 displays as
$1,000.0075.
A date value The value is preserved as entered and treated as
text, not as a date, in formulas.
For example, 1/1 displays as 1/1.
A Boolean value The values “true” and “false” are converted to
“TRUE” and “FALSE.” These cells can be used in
Boolean operations in formulas.
A percentage value A number followed by the % sign is displayed as
entered, and in formulas the value is treated as
a percentage value. A space before the % sign is
not required.
For example, you can type 5% or 5 %.
A scientific value The display format rounds the value to 2
decimal places.
For example, 1.777E3 is displayed as 1.78+E3.
A duration value The value is preserved as entered and treated
as text.
A fraction value The value is preserved as entered and treated
as text.
Applying a Number Format to Table Cells
Use the number format to format the display of a number’s decimal places, thousands
separator, and negative values.
To apply a number 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 Number from the Cell Format pop-up menu.
5 To specify how many decimal places to display, use the Decimals field. 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.
180 Chapter 10 Using Tables