Thread: How do I suppress a zero value or #VALUE! for a Pivot calculated i
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
[email protected] coryholmer@gmail.com is offline
external usenet poster
  
Posts: 1
Default How do I suppress a zero value or #VALUE! for a Pivot calculated i
On Friday, February 26, 2010 at 3:56:24 AM UTC-8, Roger Govier wrote:
Hi

Right click on the PTTable Optionscheck Show Error values as, and either
leave as blank or set to 0 as you wish.

--
-------
Regards
Roger Govier


Thank you SO MUCH for this!
Reply With QuoteReply With Quote