beautypg.com

Using the date and time format, Using the fraction format – Apple Keynote '08 User Manual

Page 125

background image

Chapter 6

Using Tables

125

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 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.

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

Use the date and time format to display date and/or time values.

To define a date and time 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 Date & Time from the Format pop-up menu.

4

To specify how you want a date formatted, choose a format from the Date pop-up
menu.

5

To specify how you want a time value formatted, choose a format from the Time pop-
up menu.

Using the Fraction Format

Use the fraction format to control the display of values smaller than 1. For example, 27.5
displays as 27 1/2 when the format is Halves and as 27 4/8 when the format is Eighths.

To define a fraction format for selected cells:

1

Select the cell or cells.

2

Click Inspector in the toolbar, click the Table Inspector button, and then click Format.