View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
matelot
 
Posts: n/a
Default 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