08

124 Chapter 6 Using Tables
m If you delete a value from a cell with a format, the format isn’t deleted. To delete the
format, choose Automatic from the Format pop-up menu of the Format pane of the
Table Inspector.
m After you define a cell format, you can associate the format with multiple cells by using
autofilling. See “Autofilling Table Cells” on page 127 for instructions.
Using the Number Format
Use the number format to format the display of a number’s decimal places, thousands
separator, and negative values.
To define a number format for one or more cells:
1 Select the cell or cells.
2 Click Inspector in the toolbar, and then click the Table Inspector button.
3 Choose Number from the 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 Thousands Separator.
Using the Currency Format
Use the currency format to format the display of monetary values.
To define a currency format for one or more cells:
1 Select the cell or cells.
2 Click Inspector in the toolbar, and then click the Table Inspector button.
3 Choose Currency from the Format pop-up menu.
4 To specify a currency symbol, choose an option from the Symbol 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.
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 Thousands Separator.
8 To display the currency symbol at the edge of the cell, select Accounting Style.
Using the Percentage Format
Use the percentage format to display numeric values followed by the % symbol.