formulas appear as text instead of doing as expected
 

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

formulas appear as text instead of doing as expected
 

Check your options and make sure 'display formulas in cell' is not checked.
--
Brevity is the soul of wit.


"Papa Jonah" wrote:

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

formulas appear as text instead of doing as expected
 

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

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

--
Regards,
Dave


"Papa Jonah" wrote:

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

formulas appear as text instead of doing as expected
 

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

Thanks,

Shail


Papa Jonah wrote:
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

formulas appear as text instead of doing as expected
 

What does ctrl+~ toggle?



"shail" wrote:

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

Thanks,

Shail


Papa Jonah wrote:
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

formulas appear as text instead of doing as expected
 

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



Papa Jonah wrote:

What does ctrl+~ toggle?

"shail" wrote:

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

Thanks,

Shail


Papa Jonah wrote:
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



--

Dave Peterson

formulas appear as text instead of doing as expected
 

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


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 12:16:02 -0700, Papa Jonah
wrote:

What does ctrl+~ toggle?



"shail" wrote:

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

Thanks,

Shail


Papa Jonah wrote:
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

formulas appear as text instead of doing as expected
 

<<<"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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Papa Jonah" wrote in message
...
What does ctrl+~ toggle?



"shail" wrote:

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

Thanks,

Shail


Papa Jonah wrote:
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