software

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

quot;jwbassquot; wrote:

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


Make sure it is not formatted as text--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=500684And after reformatting, select all the cells and do a Find and replace,
replacing all quot;=quot; withquot;=quot;

--
Kind regards,

Niek Otten

quot;pinmasterquot; gt; wrote in message
...
gt; Could be that your cells are formatted as text, format as General.
gt;
gt; HTH
gt; JG
gt;
gt; quot;jwbassquot; wrote:
gt;
gt;gt; When I add a VLOOKUP function and fill down, the formula, not the
gt;gt; resultant
gt;gt; value, is displayed in the cells. The DISPLAY FORMULA checkbox in
gt;gt; OPTIONS in
gt;gt; not checked.
gt;gt;
gt;gt; Thanks!