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


"josvill2010" wrote:

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?

--
Thanks for your help,
Josvill2010