This isn't a global issue. I was not aware of the CTRL- ` shortcut to show
formulas.

The cell was set to text before the formula was originally entered.
Subsequent resets to anything else are not working.

Again, why would any format change ignore the leading '='?

I am looking at tearing down this entire worksheet and starting over. Even
Visicalc did not have this problem.


"Mike H" wrote:

Hi,

Ensure the cell is formatted as general before you enter the formula

OR

Hold down CTRL and tap `

The ` symbol is generally found to the left of the 1 key

Mike



"BS" wrote:

We recently upgrade to Office 2007. I have used Office products since 1995
and am a developer.

Often when I enter a formula in a cell, say: =IF(ISNUMBER(G2),0,1), the
expression is treated as though it were a string. There is no leading quote
and no result.

what is up?