Formula

  • Thread starter Thread starter josvill2010
  • Start date Start date
J

josvill2010

Hi,

I was using Vlookup formulas and now of sudden the formula appears on the
spreadsheed like if it was a text. What can i do to fix that?
 
You never said what version of Excel (only of interest because the method
changes slightly with each), I hope this deals with your problem!

in 2007 click the multicoloured button, choose excel options, go to
"advanced" and you will see under display options "show formula's instead of
results" - uncheck it.

if not in 2007 use the help file for "display formulas"

hope that helps
 
Back
Top