View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Douglas O''Neill
 
Posts: n/a
Default Pivot Table formatting in office 2003

I have a pivot table that uses data from a list that is formatted as a number
with two decimal places. I formatted the field in the pivot table with the
same format. However, when I do a refresh, it will lose the formatting and
apply about 10 decimal places instead. Any ideas?