View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Why do formulas appear and not the result?

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