Changing the Cell Data Type

Every cell has an assigned data type.

The default data type is General, but you can change it in the Properties palette or by using the editing tools from the Edit Table contextual toolbar.

You cannot change the data type of a cell that contains a formula.
The following data types are available:
  • Angle
  • Currency
  • Date
  • Decimal number
  • General
  • Note
  • Percentage
  • Point
  • Whole number

If a formula cannot identify the data type, it returns an error and the cell displays "####".

To change the cell data type:

  1. In the graphics area, click inside a cell to select it.
  2. Do one of the following:
    • On the ribbon, click Table > Data and select the data type.
    • On the Edit Table toolbar, in the Data flyout, select the data type.