Using the currency format, Using the percentage format – Apple Pages '08 User Manual
Page 179

Chapter 8
Using Tables
179
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, click the Table Inspector button, and then click Format.
3
Choose Currency from the Cell 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.
If the value is used in a formula, its decimal number version is used. For example, a
value that displays as 3% is used as 0.03 in a formula.
If you type 3% in a cell formatted using the automatic format and then apply the
percentage format to the cell, the value displayed is 3%. However, if you type 3 in a cell
formatted using the automatic format and then apply the percentage format to the
cell, the value displayed is 300%.
To define a percentage format for one or more cells:
1
Select the cell or cells.
2
Click Inspector in the toolbar, click the Table Inspector button, and then click Format.
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 Thousands Separator.