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?
|