Pivot table drill down formatting
 

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

Pivot table drill down formatting
 

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

"matelot" wrote:

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