How did you change the format in the pivot table?

You can format pivot table cells the way you do any other: select them, right
click, choose Format Cells..., specify the format you want.

--
Regards,
Fred


"Titanium" wrote in message
...
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.