Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivot Table
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot Table
Resolved · Low Priority · Version 2007
Reply Tue 31 Mar 2009, 16:38Delegate Sandip said...
Sandip has attended:
Excel VBA Intro Intermediate course
Pivot Table
How do you format the cells for Pivot Tables when running a report
For upcoming training course dates see: Pricing & availability
RE: Pivot Table
Hi Sandip
To format a pivot table's data you need to decide which format to use, then you write the following code:
Sheets("The Sheet").PivotTables("MyPivotTable").DataBodyRange.NumberFormat = "$#,##0"
If you want to group the row values you could also do the following (In this example there are dates in the row area):
Range("A4").Select
Selection.Group Start:=True, End:=True, Periods:=Array(False, False, False, _
False, True, False, False)
Regards
Carlos
|