1. Home
  2. Displaying Factors as Ordinals, Levels or Labels

Displaying Factors as Ordinals, Levels or Labels

The spreadsheet shown below displays text labels for the Sex and Severity columns and displays numeric levels for the Age and Treatment columns. You can change the display of a factor column to use either ordinals, labels or levels.

Changing a single column

  1. From the menu select Spread | Factor then select one of the following options:
    • Display Ordinals
    • Display Levels
    • Display Labels

Note: If the level values are the same as the ordinal values i.e. 1, 2, 3, the Display Levels option will be greyed out as it is unnecessary.

Changing multiple columns

  1. Double-click a column name or press F9 on your keyboard to open the Column Attributes dialog.
  2. Ensure the correct factor column is displayed in the Column list.


  3. In the Display factor as section select the required option.
  4. Click Apply to keep the dialog open so you can select another column or click OK to close the dialog.

Updated on May 17, 2019

Was this article helpful?