Hi all,
I have a pivot table that automatically works out the average for a large set of scores for people...
However, the pivot table does not display this as a percentage, but rather just 90, 66.666667, 100, etc...
When I try to format the cell it changes it to 9000% etc...
Is there a way of formatting this correctly?
Not too important, but would look better in presentations.
So it sounds as though the source data is meant to be a % but is stored as a numeric -- ie 90% is stored as 90 ?
To get it to appear as a % (without adding a further field to your source data) you can format your current averages to "appear" to be a % value though the underlying values will persist (ie 90 will show as 90% but the underlying value remains 90 not .9)
To do this, double click on the header of your Avg field in the PT set a Custom Number Format for said field of:
###.00"%"
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
neilpateluk 
Register To Reply
Bookmarks