Excel Calculator always requires an = before a math function, can be turned off setting?

[auto]

I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.

 

[Biff]

I always have Excel running and it's also my calculator. I never use use a
calculator anymore!

The answer to your question is no.

The equal sign tells Excel that you're entering a formula that needs to be
calculated.

You can use a plus sign (+) instead of the equal sign (=) if you always use
the numeric keypad. It's more ergonomic than "reaching" for the equal sign.
Excel will accept the plus sign and upon hitting ENTER, will automatically
change it to an equal sign.

+44+66 [Enter]

Biff

 

[Biff]

See reply in .Functions

Biff

 

[Gord Dibben]

No way to turn that off.

Type in the = sign.

Same like starting your car..........need to insert key and turn to start.


Gord Dibben MS Excel MVP

 

[auto]

thanks, I did not realise it convert the + to an =.
Was it always like that, even in the older excel versions?

I always have Excel running and it's also my calculator. I never use use a
calculator anymore!

The answer to your question is no.

The equal sign tells Excel that you're entering a formula that needs to be
calculated.

You can use a plus sign (+) instead of the equal sign (=) if you always use
the numeric keypad. It's more ergonomic than "reaching" for the equal sign.
Excel will accept the plus sign and upon hitting ENTER, will automatically
change it to an equal sign.

+44+66 [Enter]

Biff

I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.

 

[auto]

no sure what you mean by that?

See reply in .Functions

Biff

 

[Biff]

Was it always like that, even in the older excel versions?

I'm not sure how far back it goes.

Biff

thanks, I did not realise it convert the + to an =.
Was it always like that, even in the older excel versions?

I always have Excel running and it's also my calculator. I never use use
a
calculator anymore!

The answer to your question is no.

The equal sign tells Excel that you're entering a formula that needs to
be
calculated.

You can use a plus sign (+) instead of the equal sign (=) if you always use
the numeric keypad. It's more ergonomic than "reaching" for the equal sign.
Excel will accept the plus sign and upon hitting ENTER, will
automatically
change it to an equal sign.

+44+66 [Enter]

Biff

I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget
to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.

 

[Biff]

no sure what you mean by that?

Your message was also posted to the Worksheet.Functions forum where there
are also replies.

Biff

 

[auto]

i c, tx

Your message was also posted to the Worksheet.Functions forum where there
are also replies.

Biff