pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · Low Priority · Version 2007

James has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

Within a pivot table is there any easy way to format all the numbers so they format doesn't always revert back to standard every time the pivot table is refreshed

RE: Pivot Tables - Formatting numbers

Dear James

Thank you for attending Excel Adv course. I hope you enjoyed the course and benefited from it.

Once you have created a pivot table then you simply right-click on any of the cell containing the number and choose number format...

Choose the currency from the list and the decimal places you want.

Press OK.

All the cells with numbers will be currency format.

Please remember that Pivot table is interactive where the fields can be moved around therefore as soon as you remove the field from the pivot table and drag and drop the same field it reverts back to the general number formatting i.e. the currency formatting is lost.

The best thing to do is once you got the numbers then select all the cells in the pivot table and right-click on the cells and choose Format cells... and then choose currency and press OK.

The problem with this is that if in the future you are trying to count certain data it will be formatting as currency.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips


Server loaded in 0.18 secs.