Apple Keynote Uživatelská příručka stáhnout pdf (Strana 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 scientic 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 eld. 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

1 2 ... 175 176 177 178 179 180 181 182 183 184 185 ... 246 247

Žádné komentáře

Apple Keynote Uživatelská příručka Strana 180