Hello - I'm using Excel ver 2007 and have a pivot table that has both counts and %'s. When I double click for the detail behind the pivot, the number formats are all general. I just want only the % column to show as a % and leave the other two columns showing as they are. I've been all over the net looking for a solution and I'm hoping there is one. I need this to show upon double clicking and not have to manually reformat the drill down data each time. Is there a way to do this in 2007 or 2003?? Thanks!
Bookmarks