Display Value for Empty Cells

By default, a 0 is displayed in empty cells (cells that contain no cases). You can instead display nothing in these cells (leave them blank) or specify a text string to display in empty cells.

  1. Open the table builder (Analyze menu, Tables, Custom Tables).
  2. Click the Options tab.
  3. In the Data Cell Appearance group, for Empty Cells select Text and type None.
  4. Click OK to create the table.
Figure 1. Table with "None" displayed in empty cells
Table with "None" displayed in empty cells

Now the four empty cells in the table display the text None instead of a value of 0.