On Mar 24, 10:58 am, "Roger Govier" wrote:
Strange that it drops the leading "+" for numerics,
but not with alphnumerics.

I think it would be strange if it did. Your way makes sense. It
would be strange if Excel's often-capricious heuristics began to make
sense. If they did, I would question our sense of what makes
sense. :-) :-) :-)

PS: Thanks for the explanation. It, well, makes good sense.

PPS: In fairness to MS, wasn't this dichotomy of behavior cloned from
a market leader in spreadsheets at the time, c. 1984?



----- original posting -----

On Mar 24, 10:58*am, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
Whilst you are undoubtedly correct, Dave, there can be another reason.

On a full size keyboard with numeric pad, entering +61+32 changes to =61+32
and is a lot faster than having to move your cursor up to the top row of
numbers to reach the "=" sign.
Some people who do a lot of keyboard entry, get into the habit of hitting
that "+" key, hence do the same when entering a formula and just type
+A1+B1, which Excel changes to =+A1+B1
Strange that it drops the leading "+" for numerics, but not with
alphnumerics.

--
Regards
Roger Govier

"Dave Peterson" wrote in message

...



It usually means that the author of the formula started with Lotus 123.

In lotus, you could start a formula with +
+a1+b1

Excel starts with an equal sign:
=a1+b1

But some people have muscle memory and can't stop typing that + even
though they
don't need it.

sabi wrote:

Placing a + infront of a sum means what?- eg:=+SUM(C6+C8+C10)

--

Dave Peterson