View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default I can't get my formulas to disappear

Tools|options|view tab|uncheck formulas (the menu equivalent of the
ctrl-backquote shortcut)

But your cells could be formatted as text, so excel sees the strings as plain
old text--not a formula to evaluate.

Try formatting a cell as General (or anything but Text)
and with that cell still selected, hit F2, then enter.

If that works, then try formatting all the offending cells as General, then with
that range selected:
edit|Replace
what: = (equal sign)
with: =
replace all



jalbert1975 wrote:

All of a sudden, all of my formulas are appearing instead of their output. I
have tried Ctrl+`, and Tools-Formula Auditing-Formula Auditing Mode. I
can't get rid of them. This just started yesterday, and I have no idea why.
What can I do?


--

Dave Peterson