Pivot Table - How to Set and Preserve my Formating for all futurepivots

  • Thread starter Thread starter Negda
  • Start date Start date
N

Negda

I usually want number to present with "," as thousands seperator and
without any fractionals (for example). I can change the original
format but I can't preserve it for other scenarious - is there a way?

thanks,
Negda
 
In pivot table u can see count of or sum of ......

Double click on that u will find pivot table field | click number |
number category | number| tick the 1000 separator | decimal places
make to zero | ok | ok
 
use this

select the values in pivot table and run this macro

Sub Macro1()
Selection.NumberFormat = "#,##0"
End Sub
 
Inpivottableu can see count of or sum of ......

Double click on that u will findpivottablefield | click number |
number category | number| tick the 1000 separator | decimal places
make to zero | ok | ok




- Show quoted text -
Click to expand...

thank you Muddan, but this method is for one time. next pivot i need
to do it again...
negda
 
Back
Top