M Mav_2006 Joined Jun 16, 2008 Messages 6 Reaction score 0 Aug 6, 2008 #1 I have a pivot table that I have formatted to 2dp. However, when I drill down on the data it shows all decimal places. I had thought to format the sheet, but the drill down inserts a new sheet every time. Any ideas/welcome
I have a pivot table that I have formatted to 2dp. However, when I drill down on the data it shows all decimal places. I had thought to format the sheet, but the drill down inserts a new sheet every time. Any ideas/welcome