View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shanks Shanks is offline
external usenet poster
 
Posts: 1
Default Formatting numbers in excel pivot

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