View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
donpayette donpayette is offline
external usenet poster
 
Posts: 2
Default Replacing blank cells with zeros

I have a spreadsheet (500ishx40ish) that either has a number 0 or a blank.
I need to go through and insert a "0" in any cell that is blank. I cannot
come up with any conditional processing to do this and would like to avoid
having to manually go through all these cells and enter "0" where needed.

Suggestions?

Thanks!
Don