Apple Numbers '09 - Manual (Page 98)

To define a numeral system format, select one or more cells, choose Numeral System
from the Cell Formats pop-up menu in the format bar, and then use the Cells inspector
to specify the format.
To define a numeral system format for selected cells using the Cells inspector:
1 Select the cell or cells.
2 If the Cells inspector isn’t already open, click Inspector in the toolbar and then click the
Cells inspector button.
3 Choose Numeral System from the Cell Format pop-up menu.
4 Use the Base field to specify the base value of the numerical system you want to use.
5 Use the Places field to specify the total number of digits to display.
6 If you selected Base 2, 8, or 16, select an option for displaying negative values.
Minus Sign: Displays negative values with a leading minus sign.
Two’s-Complement: Displays negative values using two’s-complement notation.
Negative values in all the other numerical systems are always displayed using a
leading minus sign.
Using the Scientific Format in Table Cells
Use the scientific format to display numbers using an exponent raised by the power of
10. The exponent is displayed following an “E.” For example, the value 5.00 in scientific
format displays as 5.00E+00. And the value 12345 displays as 1.23E+04.
To define a scientific format that displays two decimal places, select one or more cells,
click the Cell Formats button in the format bar, and then choose Scientific from the
pop-up menu.
98 Chapter 4 Working with Table Cells