< I have then formatted it to text

That's the problem. The cell should be formatted as General (or Number) before you enter the formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Frank Costa" wrote in message ...
|I have read previous bulletins about this where after entering a formula
| (starting with an "=" sign, it shows up as text versus the result. I have
| done the following:
| 1) Checked to see if the ToolsOptionsView box is unchecked.
| 2) Verified the format to make sure it is listed as a number (though it
| should still be allowed to be text).
| 3) Taken a different cell, entered "=1+2" (of course, without quotes) to
| make sure that the result is "3" and copied it into the cell i'm having an
| issue with (and it gives me the result of "3"), I have then formated it to
| text and still get the "3" result. But then, when I make a change to put in
| the formula I need, it just shows up as text, starting with an = sign.
| 4) I've tried to copy and paste the whole worksheet into a new worksheet (so
| that the defaults are there) but that doesn't work.
|
| I have found a work around, which is to do a 'replace' when the cell gives
| me the formula, but this is a huge pain in the neck and is taking me way too
| long. It is also giving me very little confidence that the error won't
| appear at some time in the future.
|
| I have also found that I can take some formulas that are requesting a
| blank/" " to show up in the cell (versus a 0) so that it doesn't get counted
| with my COUNTA formula, but in some cells it shows as a blank, and others as
| a zero 0. Again, with me verifying the format of the cell and even cutting
| and pasting from one that works.
|
| PLEASE HELP ME! THANKS IN ADVANCE