Originally Posted by CNW

I have blank cells that I replaced with "-". I have a formula using those cells, but it gives me #VALUE! INSTEAD OF "-". How do I get the formula to recognize "-" as zero? Thanks in advance for any help!