vlookup formula appearing as formula

  • Thread starter Thread starter Todd F
  • Start date Start date
T

Todd F

I am doin ga vlookup and it keep sshowing up in the cell
as a written formula and not the value.

I have tried formatting as text and general and then
redoing and still appears in formula format.

What is going on here.

Thanks
 
Hi Todd,

Try pressing the Control key and the back-tick (next to the number one
key). That's CTRL+`

Hope this helps!
 
Thanks it worked - but what causes and how does your fix
work.

Also fyi - Running on office 2003
 
Todd

That is the shortcut key for Tools>Options>View "Window Options" Formula

Someone must have turned on the Formulas View.

Gord Dibben Excel MVP
 
Back
Top