Hi,
I produce pivot tables that detail time worked by month but I receive the
information in the following date format: 01/10/08, 02/10/08 etc. I want to
be able to format the date so that the name of the month appears (prior to
running the pivot) i.e OCT.
I have tried using custom formatting i.e MMM which is OK but when I run the
pivot the individual days still appear in separate columns and not just the
total for OCT in one column.

Please can anyone help.

Thanks
Sandy


--
SandyW