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.