I can't get my formulas to disappear
 

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?

I can't get my formulas to disappear
 

Never mind, I found the solution on another post.

"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?

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