View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Getting rid of '0' in a cell

When referencing an empty cell, like in 'Sheet A'!B3:B6 from Sheet B, instead
of displaying an empty cell as well, I get a 0 in it. How do I get rid of
this strange behaviour? Note: the cell format is General, switching to Text
did not help ...