Formattting the date in a Pivot Chart

Hi There

Appreciate any help with this.

I have a pivot chart with the following date format:
6/11/2011

Now I want to change it into the following date format:
6/11/2011 0:00

To do this I get the following Macro after recording it

Please Login or Register  to view this content.

But if I run this Macro(Macro4) it changes the PivotField “Time” to “d/mm/yyyy h:mm “, which is not what I want.

Can anyone please help me correct this?? See attached.




Building from this I have multiple sheets with Pivot Charts with the date format:

6/11/2011

I have created the following Macro that will go through every Pivot Chart in every Pivot Sheet and hopefully change it to the format I want:
6/11/2011 0:00

The Macro is below, but it is not doing what I want it to do. As I have copied the line from the recorded macro above.

Please Login or Register  to view this content.

So I think if I get this line of code right I will be all set.

Please Login or Register  to view this content.

Thanks