View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default what does the += operator do? cannot find any help on it.

"Bob Umlas" wrote:
AND, it doesn't do anything.


Not quite correct. Excel 2003 does recognize +2+3 as a formula, equivalent
to =2+3, whereas 2+3 is treated as a string.

Someone once noted that there is still some benefit to treating the leading
"+" in this way. Namely, for people who use a numeric keypad for fast data
entry, they can enter simple constant formulas. The numeric keypad
typically does not have a "=".

BTW, I cannot enter +=2+3 in my revision of Excel 2003. Excel flags it as
an error and offers +2+3 (!) as a correction. Moreover, when I enter +2+3,
it is changed to =2+3 in the Formula Bar.

So I wonder how the OP is seeing his situation. Or do I have some option
set that I've forgotten and cannot find now?


----- original message -----

"Bob Umlas" wrote in message
...
AND, it doesn't do anything.

"Bob I" wrote in message
...
the PLUS sign is leftover from the days of Lotus, it is not needed.

dwneumann wrote: