+AD4- I pull information in from an Essbase database. It puts missing
+AD4- information in the cell as a text '0. I want to be able to replace '0
+AD4- with a 0. Or how would I set up my formula's to recognize the
+AD4- apostrophe?
+AD4-
+AD4- +AD0-IF(C275+AD0-0,0,(+-B275-C275)/C275)
+AD4-
+AD4- So it doesn't come out like this? +ACM-DIV/0+ACE-


One way is to select an empty cell and use
Edit +AD4- Copy

Then select a range of cells and use
Edit +AD4- Paste special +AD4- Add

The idea is that adding zero takes a number in text form and changes it to
a number in numerical form, but doesn+IBk-t change other stuff much. (If
there+IBk-s a formula, it adds +-0 at the end.)