Number Entry

I have long favored L123 ability to accept the entry of a
series of numbers in a single cell, ie 10+27+3 to result
in a sum of 40.

In excel you have to include either a "+ or =" before the
first number. This becomes a problem when you are editing
a cell with a single number with a second, it turn in to a
label unless you backspace and add the = sign.

Anyone know a setting that will allow a series of numbers
to be entered without having to proceed them with the
operator.

Thanks

Thanks


>-----Original Message-----
>Hi Bob
>
>It's very obvious (just kidding):
>
>Menu Tools > Options > Transition > check Transition
Formula Entry. Ok your way out.
>
>--
>HTH. Best wishes Harald
>Excel MVP
>
>Followup to newsgroup only please.
>
>"Bob Lewis" <BobLewisPA@hotmail.com> wrote in message
>news:02eb01c34c9d$785049d0$a401280a@phx.gbl...
>> I have long favored L123 ability to accept the entry of
a
>> series of numbers in a single cell, ie 10+27+3 to result
>> in a sum of 40.
>>
>> In excel you have to include either a "+ or =" before
the
>> first number. This becomes a problem when you are
editing
>> a cell with a single number with a second, it turn in
to a
>> label unless you backspace and add the = sign.
>>
>> Anyone know a setting that will allow a series of
numbers
>> to be entered without having to proceed them with the
>> operator.
>>
>> Thanks
>
>
>.
>