Pivot table drill down formatting

[Guest]

I am using a pivot table with the right formatting but everytime I
double-click to drill down to see the details, all my formattings are not
retained. For example, I have a column formatted as currency $ and it reverts
to just default Excel number. My ratio column is set to 2 decimal points but
when I drill down, it shows 9 decimal points. Is it possible to keep the same
format when drilling down?

Thanks

 

[Guest]

If you click on the column, then right click you should get a drop down menu
with the option of field settings. If you select that option you then get
another menu that has a button called Number.... this enables you to
permanatly format your pivot and it should be retained when you refresh.

Marlyn