Formula

[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?

 

[Dianne]

Hi,

I was using Vlookup formulas and now of sudden the formula appears o the
spreadsheed like if it was a text. What can i do to fix that?

Try holding down ctrl key and then clicking the accent key (abov
tab/tilde key and just below the esc key usually).

 

[getting old]

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