formulas appear as text instead of doing as expected

P

Papa Jonah

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
 
D

David Billigmeier

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

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

shail

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

Thanks,

Shail
 
D

Dave Peterson

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

Gord Dibben

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


Gord Dibben MS Excel MVP
 
R

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.
 
Top