Apple Numbers '09 - Manual (Page 108)

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
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.
108 Chapter 4 Working with Table Cells