How to replace '0 with a 0?
I pull information in from an Essbase database. It puts missing
information in the cell as a text '0. I want to be able to replace '0
with a 0.
One way:
1. select an empty cell and
Edit Copy
2. Select the range of cells to be affected and
Edit Paste special Add
This adds zero, so it leaves numbers unchanged but changes '0 to 0.
Or how would I set up my formula's to recognize the
apostrophe?
=IF(C275=0,0,(+B275-C275)/C275)
So it doesn't come out like this? #DIV/0!
One way:
=IF(N(C275)=0,0,(+B275-C275)/C275)
|