Apple Numbers '09 - Manual (Page 95)

Chapter 4 Working with Table Cells 95
For more control over the percentage format, use the Cells inspector.
To define a percentage format using the Cells inspector:
1 Select the cell or cells.
2 Click Inspector in the toolbar, and then click the Cells inspector button.
3 Choose Percentage from the Cell Format pop-up menu.
4 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.
5 To specify how to display negative values, choose an entry from the pop-up menu
adjacent to the Decimals field.
6 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%.
Using the Date and Time Format in Table Cells
Use the date and time format to display date and/or time values.
To define a date and time format, select one or more cells, click the Cell Formats
button in the format bar, choose Date & Time from the pop-up menu, and then choose
an option from the submenu.
Cell formats button
Choose More to apply
the template’s default
date/time format and
open the Cells inspector.
For more control over the date and time format, use the Cells inspector.
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 Cells inspector button.
3 Choose “Date and Time” from the Cell Format pop-up menu.