Pivot table macro and text instead of numbers help

[bloodmilksky]

Hi Guys,

I am very new to pivot tables and I was just wondering if anyone can help.

I have a pivot table set up at the moment for out of stock orders.

• Report Filter - Account number Example : 12008003
• Row Labels - Order Number Example 818042187
• Row Labels - Item Description Example Apples
• Values - Order Qty 2
• Values Comments (Text But is showing as number)

I was wondering if anyone knows of how to change Values Comments from Numbers to Text and Also if anyone knows of a macro that would automate selecting each number in the Report Filter?

any help would be greatly appreciated.

many thanks

Jamie

 

[Marcelo Branco]

First question:
https://www.youtube.com/watch?v=wslp2BqHuz8

Second
http://www.contextures.com/excelpivottablereportfiltervba.html

Hope this helps

M.