Specifies the type of data in the PivotTable field.

Version Information
Version Added: Excel

Name Value Description
xlDate 2 Contains a date.
xlNumber -4145 Contains a number.
xlText -4158 Contains text.

Remarks

This enumeration is used with the DataType property of the PivotField object.