Pivot Table Drilldown - % formatting

[JonDallard]

Hi all,

I have a pivot table drawing on a data table holding %'s. When I use drill down it brings through the %'s but they are not formatted as %'s.

For example in the data table I have a value of 75%, when using the pivot drill down the output is 0.75.

Is there a way of getting excel to format the output of drill down to % without having to manually do it each time??

Any help would be great
Thanks
Jon