View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abbey Normal Abbey Normal is offline
external usenet poster
 
Posts: 16
Default replace null cells within a range to 0

Hi. Is there a way to check a range of cells within a worksheet to see if
they are null, and if so to replace it with a zero? I tried reformatting the
column, but it doesnt do anything with the nulls. It needs to be a number
because I am importing it to a linked file.
Thanks,