View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kristin Kristin is offline
external usenet poster
 
Posts: 43
Default How do I default blank cells to "0"?

In an Excel spreadsheet I have created a formula which includes blank cells,
which gives me an error. If I change the blank cells to "0" than the formula
is accepted. The spreadsheet is large and would be very time consuming to go
through and add a zero to each blank cell. Is there a way to change the cells
automatically?