Pivot Table / Format cells

R

Romily

I am setting up a pivot table at the moment, and part of my source dat
is formatted at percentage. In the pivot table it shows the data as 0.
instead of 60%.

I found out how to format the cell, by rightclicking it and going t
select, enable selection, and then format / percentage. It now show
60%

My problem is that I have a pull down menu at the top, with 100 names
And when I choose the name Andy for example, and format the cell a
percentage, it works, but as soon as I choose another name, for exampl
ben, the fild is unformatted again, eg shows 0.6.

Surely I don't have to go through the process of enable selection an
format the cell for each name separatly? That would take forever!!
Does anybody know a better way to do that? Or do I have to change m
source data?

Thanks for your help!!
 
D

Debra Dalgleish

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
Click OK

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection


To format a section of a pivot table, e.g. subtotals --
Move the pointer to the left of a subtotal heading in the pivot table.
When the black arrow appears (like the one that appears when the pointer
is over a row button), click to select the subtotal rows in the pivot
table.
Format the selected subtotals
 
Top