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?