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 apply the scientific format:
  1. Select the cell or cells.

  2. Click Inspector in the toolbar, and then click the Table button.

  3. In the Table inspector, click Format.

  4. Choose Scientific from the Cell Format pop-up menu.

  5. Use the Decimals field to specify the number of decimal places to display.

To learn about other cell format types, see Formatting Table Cell Values for Display.

Was this page helpful? Send feedback.