Pivot Table - NUMBER FORMAT option does not appear in field settin
Excel 2007 Pivot Table - The "Number Format" option does not appear in the
field settings for one of my columns that is formatted in the data table as a
number.
It is showing up as a date format by default.
I can change the format in the pivot table to number but then each time the
Pivot Table is changed or refreshed the format reverts back to the MM-YY
format.
|