Formulas act like text

[Bill Park]

When I try to enter a formula, it acts as if it is text. If I try co copy
from the formula line and paste to the formula line of the destination cell,
the same thing happens. When I click to the right of the formula in the
formula line, it says VLOOKUP in the Functions space to the far left, even
though there is no vlookup function being invoked in the entire sheet?

I don't even know how to describe the problem well.

Any suggestions would be appreciated.

 

[Gord Dibben]

Bill

Any cell in which you enter a formula?

Could be you are in View Formula mode.

Hit CTRL + '(backquote above Tab key) to toggle this setting.

OR your cells may be pre-formatted as text.

Change formatting to Genral then F2 and ENTER to re-enter the formula.

The VLOOKUP in the namebox to the left is just the Function Wizard trying to
help you.

If you hit the dropdown arrow you will see a list of Functions.


Gord Dibben MS Excel MVP

 

[Bill Park]

Thanks much, using the General F2 thing I can enter in new formulae but if I
try to edit the formula, it becomes text again. But I'm getting around the
problem!

Thanks.