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