pivot table drill down range auto formatting to %

[koi]

Hi All,


i have a problem with pivot drill down, i set up that pivot using table..and inside the table i format some of the range with %.


now when i double click the pivot table..drill down will appear but some range formatted in General mode,


can we use macro somehow to make some range (let say D:E) to automatically formatted in % ?


thanks so much for the advice

 

[koi]

hi All,


i found the solution by recording macro and browsing in google,


just paste this code into "thisworkbook" and change the columns range as you like.. and in my case i need to formatted as % so you can change the formatting as you like


Private Sub Workbook_NewSheet(ByVal Sh As Object)

Columns("L:T").Select

Selection.NumberFormat = "0.0%"

End Sub