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 207 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.
212
Chapter 9
Working with Table Cells
Chapter 9
Working with Table Cells
213
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
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