View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default 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!