Hi

Double click on the relevant data field and choose NumberFormat from
there, rather than formatting the cells where the PT is displayed

--
Regards

Roger Govier


"Shanks" wrote in message
...
Hi

I create pivots many times and have problem in formatting number
column.
Everytime I change contents of pivot table,the number column returns
to
general state, from "coma" format.

Can I save / set the format once for all ? so with whatever changes in
pivot
columns the number format can remain constant?

Please help
Thanks in Advance
Shanks