I want to control the appearance of a pivot table report by replacing the
"(blank)" entry in some cells of the pivot table with a truely blank
appearance. I can do this by entering a zero in the data area that the pivot
table refers to and setting the sheet to return an empty cell for the
reported zero, but I cannot guarantee that other users of the sheet and it's
pivot reports will always enter zeros in cells that do not need an entry in
the data area. Peter Gilbert, New Zealand.