Numbers - Defining the Scale of a Custom Number Format

background image

Defining the Scale of a Custom Number Format

The Scale element lets you display a number entered into a table cell using
percentage, scientific notation, or other value sizing conventions.

To use the Scale element:

1

Add it as “Creating a Custom Number Format” on page 102 describes.

2

Select it in the format field, click its disclosure triangle, and then choose an option.

When you apply a format that includes a scale element to a cell that already contains
a value, the original value is preserved (it’s just displayed differently). When you apply
the same format to an empty cell and then add a value to the cell, the actual value
takes into account the scale you’ve specified. The following table illustrates these cases.

106

Chapter 4

Working with Table Cells

background image

Chapter 4

Working with Table Cells

107

For this scale option

When you enter 12000
in a table cell

The actual value is

The displayed value is

Percent

And later apply the
option

1200000%

1200000

After applying the
option

1200000%

12000

Percent (%)

And later apply the
option

1200000%

1200000%

After applying the
option

12000%

12000%

Hundreds

And later apply the
option

12000

120

After applying the
option

12000

120

Hundreds (C)

And later apply the
option

12000

120C

After applying the
option

12000

120C

Thousands

And later apply the
option

12000

12

After applying the
option

12000

12

Thousands (K)

And later apply the
option

12000

12K

After applying the
option

12000

12K

Millions

And later apply the
option

12000

0

After applying the
option

12000

0

Millions (M)

And later apply the
option

12000

0M

After applying the
option

12000

0M

Billions

And later apply the
option

12000

0

After applying the
option

12000

0

background image

For this scale option

When you enter 12000
in a table cell

The actual value is

The displayed value is

Billions (B)

And later apply the
option

12000

0B

After applying the
option

12000

0B

Trillions

And later apply the
option

12000

0

After applying the
option

12000

0

Trillions (T)

And later apply the
option

12000

0T

After applying the
option

12000

0T

Scientific

And later apply the
option

12000

1E+0.4

After applying the
option

12000

1E+0.4