How to Change the Missing Data (NaN) Symbol in Tables

Oliver Harrison

Introduction

This article describes how to go from a table with missing data (NaN)...

...to a table where the NaN has been replaced with specified text (e.g. - ):

A table.

1. Select your table.

2. Go to Properties > RULES on the object inspector.

3. To apply the rule, select the Plus (+) > Browse Online Library > Modify Cell Content > Change Missing Data (NaN) Symbol.

4. Enter the text to replace the missing data (NaN).

5. Press OK.