The Scale element lets you display a number entered into a table cell using percentage, scientific notation, or other value sizing conventions.
-
Add it as Creating a Custom Number Format describes.
-
Select it in the format field, click its disclosure triangle, and 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.
|
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 |
|
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 |