Try this:

Select a "bad" formula, then:
<Edit <Replace
In the "Find What" box, enter
=
In the "Replace With" box, enter
=
Then hit <Replace.

Does that work?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Half Manx" wrote in message
...
The calculation is set to automatic and the cell format is 'number'. I
have
even tried 'F9' calc now, but that doesn't work either. I'm puzzled?

"ScottO" wrote:

It sounds like you have Calculation set to Manual. If you set it to
Automatic, it should work OK. (Go to Tools/Options/Calculation).
Rgds,
ScottO

"Half Manx" <Half wrote in message
...
| I have set a VLOOKUP formula to match account numbers. How ever I
have to
| click double click on the cell before the formula recognises the
account
| number. I have to do this for each cell. I have tried different
formats. It
| is not saving me that much time.