How can I show values, not formulas in Excel?

J

jwbass

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!
 
N

Niek Otten

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