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
Scientic And later apply the
option
12000 1E+0.4
After applying the
option
12000 1E+0.4
Associating Conditions with a Custom Number Format
You associate conditions with a custom number format to vary a table cell’s display
characteristics based on what’s entered into the cell.
Here’s a number format that has four conditions. The top condition is applied if the
number entered doesn’t satisfy any of the other conditions.
214 Chapter 9 Working with Table Cells
Comments to this Manuals