View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Titanium Titanium is offline
external usenet poster
 
Posts: 46
Default Pivot Table Date Format Question

The formating of date in the spreadsheet is mmm yyyy and it does display the
way I intend at this point, but not the pivot table. When I run a report in
the pivot table a date that is supposed to show up as May 2007, shows up as
5/07/07. I even changed the format in the pivot table to the mmm yyyy
formating but it doen't work.