Please help....Date Format issue
 

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

Please help....Date Format issue
 

You'll need another column in your data (creating another field for your
PivotTable)
Assuming dates are in column A
=MONTH(A2)
copy down, format as "mmm". Remember to give this column a label (Month)

You now use the Month field in your Pivot Table.

NOTE: Based on what you said, no distinction is made between years. All of
1/08 data would be grouped with 1/09 data.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"SandyW" wrote:

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