View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default The =+ sign we see sometime

Happy holidays to you too...

You have made an interesting observation. It works even if you start the
formula with + sign on top of the keyboard (not necessarily on the numeric
keypad)... This is because Excel knows that you are entering a formula when
you start with a + (or -) and adds an = before what you have entered...

I always start with = as I do not save any effort by starting with +

"John" wrote:

To Anyone interested!!
I see formulas posted as : =+(this,that) and noting that the plus sign being superficial ( not needed). True but
if you use the + sign on the number keypad instead of the = sign on the top of the keyboard to start your formulas, it works fine.
The result is that Excel adds the equal sign without typing it.
To some it could be more convenient.

I would appreciate any comments from the experts,good or bad.

Happy Holidays to Everyone especially those that take the time to help everyone.

Regards
John