formulas appear as text instead of doing as expected

[Guest]

I have entered a formula in a cell (B76) which reads:
=left(A76,18)
There is not a ' before the =, so I do not know why the cell displays
"=left(A76,18)" instead of "Facilities & Infra"
Protection is turned of for the worksheet and the cell.

Any ideas why?

TIA
Papa

 

[Guest]

Check your options and make sure 'display formulas in cell' is not checked.

 

[Guest]

It's probably because your cell is formatted as text. Try this:

<Format>
<Cells>
Click "General"
Commit your formula again

 

[shail]

Hi
Also try pressing CTRL+ ~ button, may be someone mistakenly pressed it
before.

Thanks,

Shail

 

[Guest]

What does ctrl+~ toggle?

Hi
Also try pressing CTRL+ ~ button, may be someone mistakenly pressed it
before.

Thanks,

Shail

 

[Dave Peterson]

ctrl-` (control backquote)
is the same as toggling tools|options|View|Formulas

 

[Gord Dibben]

View Formulas is toggled on/off by CTRL + `(same key as ~)


Gord Dibben MS Excel MVP

 

[RagDyer]

<<<"What does ctrl+~ toggle?">>>

In order to get to the " ~ ", you must <Shift> to get to the upper portion
of the key.

Selecting a cell formatted as 'Text', and containing a formula, and then
hitting:
<Ctrl> <Shift> < ~ >, will format that cell to 'General'.
Then hit <F2> to get to the 'Edit' mode,
Then hit <Enter>
And you'll have transformed the cell contents to a *working* formula.