How to get Excel to add automatically 4

[diogenes10]

In lotus when I type a number a plus sign and another number, Lotus understands I am doing a formula and treats it accordingly. When I do that in Excel it dies until/unless I go back and type an equals sign in front of the numbers. Is there somekind of Excel setting to make it behave like Lotus to get a sum without typing that first = sign?

-------------------------------------
It's 10 O'Clock ( somewhere! ).
Are your registry and data backed up?

 

[xlbo]

nope

= signifies a formula
no = signifies a constant

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question

 

[TonyJollans]

Hi Diogenes,

If you check "Transition Formula Entry" under Tools > Options > Transition tab, you should get the behaviour you want.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[xlbo]

[D'OH]

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question

 

[DPlank]

[doffs hat] to Tony. Deserves a star, I reckon...





Cheers,
Dave

Probably the only Test Analyst on Tek-Tips

animadverto vos in Abyssus!

Take a look at Forum1393 & sign up if you'd like

 

[xlbo]

I really should know better than to state that excel cannot do something ;-)

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question

 

[TonyJollans]

Indeed you should, Geoff

I always try to slip an AFAIK in there somewhere

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[diogenes10]

Hi Tony,
Thanks for the tip.

-------------------------------------
It's 10 O'Clock ( somewhere! ).
Are your registry and data backed up?

 

[DeLaMartre]

Cool, Tony! What a marvelous tip!

Worth a bunch of stars...

Thanks,

-Bob in California