View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] g.haarish@gmail.com is offline
external usenet poster
 
Posts: 6
Default Blank cells instead of zero

Hi All,

I have a sheet where I load values based on selections from dropdown
boxes. I also have the option of Drilling down on cells which will
display children below the parent cells. When I do a drill down, the
cells that do not have a numeric value change to zero and immediately
update to be blank cells. I want them to be displayed as zeros. How
can i do that? The format of these cells is 'custom' format!!!

Thanks,
Haarish.