Formulas act like text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Park - 10 Jan 2007 01:40 GMT

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.

Reply to this Message

Gord Dibben - 10 Jan 2007 01:57 GMT

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

>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,
[quoted text clipped - 5 lines]
>
>Any suggestions would be appreciated.

Reply to this Message

Bill Park - 10 Jan 2007 18:48 GMT

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.

> Bill
>
[quoted text clipped - 26 lines]
>>
>>Any suggestions would be appreciated.

Reply to this Message

Rate this thread: