View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PW
 
Posts: n/a
Default How do I stop my Pivot tables from spelling out (blank)?

Whenever I have blank cells in the source data for my pivot tables in Excel,
instead of the table returning a blank value, it spells out "(blank)". Is
there any way to return a blank value, other than through changing all of the
blank cells in the source data to " "?