Expand Minimize

XlPivotFieldDataType Enumeration

Specifies the type of data in the PivotTable field.

Version Added: Excel 2007

Name

Value

Description

xlDate

2

Contains a date.

xlNumber

-4145

Contains a number.

xlText

-4158

Contains text.

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

Show:
© 2014 Microsoft