Thanks Jacob,

I've just tried that and it didn't work.
-----------------------------------------


"Jacob Skaria" wrote:

Check the format of the cell. Right clickFormat cell...Change that to
general...from text
--
If this post helps click Yes
---------------
Jacob Skaria


"Brian Cook" wrote:

Even though I have unchecked the option to show formulas instead of their
result, I still get the formula appearing when I insert a new formula, all
the old ones show the result, it's just when I add a new one.

Any ideas? Thanks