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





On Apr 5, 10:52*pm, Negda wrote:
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

use this

select the values in pivot table and run this macro

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



On Apr 6, 1:45*pm, muddan madhu wrote:
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

On Apr 5, 10:52*pm, Negda wrote:



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- Hide quoted text -

- Show quoted text -

On Apr 6, 10:45*am, muddan madhu wrote:
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

On Apr 5, 10:52*pm, Negda wrote:



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

thanks,
Negda- Hide quoted text -

- Show quoted text -

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