98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel - Pivot Tabe Formatting
vba excel - Pivot Tabe Formatting
Resolved · Low Priority · Version Standard
Thu 4 Jan 2007, 15:27Delegate Clodagh said...
Clodagh has attended:
Excel Advanced course
Pivot Tabe Formatting
Hi
I did an excel course with yourselves last year. I have a query relating to pivot tables that I cannot find a way around. I tried to log into my delegate account but I cannot remember the password so I hope it is ok to send it to this address.
What I
Fri 5 Jan 2007, 15:33Trainer Jacob said...
RE: Pivot Tabe Formatting
Hi clodagh
One work around is to change the foramt of your dates from Month, Year to month/day/year, i.e; 01/05/2007
By doing this when you list in ascending order it will do so by month.
Hope this helps.
Training information:
See also:
|
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. |
Excel tip:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |
