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

[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

 

[muddan madhu]

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

 

[muddan madhu]

use this

select the values in pivot table and run this macro

Sub Macro1()
Selection.NumberFormat = "#,##0"
End Sub

 

[Negda]

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 -

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