View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wacNTN wacNTN is offline
external usenet poster
 
Posts: 8
Default Supress (blank) in pivottable

I have a pivottable like this.

Area Group Description
Budget
1. Strategic iniatives Business Growth Buy product X $1
Buy product Y
$5

1. Technology upgrades Convert sys A Programming $1
(blank)
$5

Excel is putting in the (blank) text because I don't have anything in the
cell in the source table and I don't have anything I want to put in that cell
- not even "Other"! Can I supress (blank) somehow? Other than putting a
space in those cells?

Thanks,

Walter

--
WAC