View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How do I default blank cells to "0"?

what's the formula?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"kristin" wrote in message
...
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?