View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Pivot Table Default

Every time I create a pivot table, I have to edit the number that I am
summing so that it is formatted as number with a comma. And often it will
default to counting instead of summing, so I have to edit that also. Is
there a way to have the default format for a number to have commas and to
default to sum not count?