Hi

It sounds as though the cells may have been pre-formatted as Text.
Mark the range of cellsFormatCellsNumberGeneral

Then try entering your formulae.

--

Regards
Roger Govier

"capnmike" wrote in message
...
I am having a similar (?) problem: when I change anything in a Vlookup
function/formula then it stops working and then the whole function appears
in
the cell as text. I have had some success by deleting the "=IF(" , then
clicking out of the cell then going back to it and re-typing the "=IF(".
I
haven't been able to find anything else about this in this discussion
group.
Please let me know if you do )
--
Capnmike


"Don" wrote:

Does anyone know why a vlookup formula would not calculate until I retype
the
lookup value in it's cell? The formatting in the lookup value cell is
exactily the same as in the table array, but until I manually retype the
lookup value cell, the formula just gives me the old #NA.

Help.
Don