How can I show values, not formulas in Excel?
 

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!

How can I show values, not formulas in Excel?
 

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!

How can I show values, not formulas in Excel?
 

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

How can I show values, not formulas in Excel?
 

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!