Apple Numbers '09 Manual do Utilizador descarregar pdf (Página 91)

Chapter 4 Working with Table Cells 91

Using the Automatic Format in Table Cells

When you add a new cell, its content is displayed using the automatic format.

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 The displayed value shows 0 decimal places if it’s

an integer ($50); otherwise it shows 2 decimal

places. If there are more than 2 decimal places,

rounding is applied.

For example, $1,000.0075 displays as $1,000.01.

A date value The value is formatted using the date format

specied in System Preferences (search for “date

format” in System Preferences) and is treated as a

date value in formulas. To view the date formats

in Numbers, open the Cells inspector and choose

“Date and Time” from the Cell Format pop-up

menu. Then select the Date pop-up menu.

A 2-digit year value greater than 50 is displayed

using the prex 19; otherwise the prex 20 is

used.

For example, 1/1 displays as Jan 1, 2008, and Jan

05 displays as Jan 5, 2008.

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.

1 2 ... 86 87 88 89 90 91 92 93

Sem comentários

Apple Numbers '09 Manual do Utilizador Página 91