Pivot table drill down formatting

Pivot table drill down formatting

Post by bWF0ZWxvd » Fri, 17 Feb 2006 02:22:26


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

Post by TWFybHl » Fri, 12 May 2006 21:28:02

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