View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Margo Margo is offline
external usenet poster
 
Posts: 18
Default How to replace #REF! with 0

I am currently pulling data from a pivot table to a report, but everytime the
pivot table doesn't have that specific data it shows #REF! on my report. I
want to change that to show 0 if there is no data. How do I fix this problem?
--
Margo