View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dmasch dmasch is offline
external usenet poster
 
Posts: 6
Default Formatting Columns in Pivot Tables

I want to have certain number formats down a column stay after a refresh but
the cell formats keep reverting back to "General". In PivotTable Options I
have AutoFormat table unchecked and Preserve formatting checked. My headers
keep their formatting but the cells below with numbers keep going back to
general with something like 9 decimal places. Any suggestions? Thanks