XlPivotFieldDataType Enumeration

Specifies the type of data in the PivotTable field.

Version Information
 Version Added:  Excel 2007

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.