When I add a VLOOKUP function and fill down, the formula, not the resultant
value, is displayed in the cells. The DISPLAY FORMULA checkbox in OPTIONS in
not checked.

Thanks!

Could be that your cells are formatted as text, format as General.

HTH
JG

"jwbass" wrote:

When I add a VLOOKUP function and fill down, the formula, not the resultant
value, is displayed in the cells. The DISPLAY FORMULA checkbox in OPTIONS in
not checked.

Thanks!

Make sure it is not formatted as text


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=500684

And after reformatting, select all the cells and do a Find and replace,
replacing all "=" with"="

--
Kind regards,

Niek Otten

"pinmaster" wrote in message
...
Could be that your cells are formatted as text, format as General.

HTH
JG

"jwbass" wrote:

When I add a VLOOKUP function and fill down, the formula, not the
resultant
value, is displayed in the cells. The DISPLAY FORMULA checkbox in
OPTIONS in
not checked.

Thanks!