Specifies the number format to apply to data field items and totals.
Contained In
PivotField, PLPivotField, PLTotal
Remarks
This element can be specified for data fields, numeric PivotTable fields, and totals.
The NumberFormat element contains one of the following string constants specifying the date or time format: General Date, Short Date, Medium Date, Long Date, Short Time, Medium Time, or Long Time; one of the following string constants specifying the numeric format: Currency, Fixed, General, General Number, Percent, Scientific, or Standard (#,##0.00); one of the following string constants specifying the Boolean values displayed: On/Off, True/False, or Yes/No; a custom format string; or the string constant General, specifying a general format that can be applied to any data type.