Sounds like the cell is formatted as TEXT.

Select the cell in question.
Change the format to GENERAL then hit function key F2 then hit ENTER.

--
Biff
Microsoft Excel MVP


"kang" wrote in message
...
there is a formula
=IF(ISERROR(VLOOKUP(A3691,A$1:A3690,1,FALSE)),"") &
IF(ISERROR(VLOOKUP(A3691,A3692:A$6867,1,FALSE)),"" )

when I change A$6867 to A6967
the formula becomes text
I mean what I see is formula itself not the result
thanks.