View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cmgedc cmgedc is offline
external usenet poster
 
Posts: 2
Default 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.