Syntax

expression.DisplayNullString

expression A variable that represents a PivotTable object.

Remarks

Use the property to set the custom null string.

Example

This example causes the PivotTable report to display "NA" in cells that contain null values.

Visual Basic for Applications 
With Worksheets(1).PivotTables("Pivot1") .NullString = "NA" .DisplayNullString = True End With

This example causes the PivotTable report to display 0 (zero) in cells that contain null values.

Visual Basic for Applications 
Worksheets(1).PivotTables("Pivot1").DisplayNullString = False
Display display character null in pivottable display custom string pivot table cell containing nulls display null string Display Null String Property displaynull DisplayNullString displaynullstring property show custom null string for pivot table

See also: