View Single Post
  #4   Report Post  
Chip Pearson
 
Posts: n/a
Default Plus sign in front of a formula

It is a holdover from Lotus 123 compatibility. It serves no
purpose in Excel, but is harmless if included.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Timmy Mac1"
wrote
in message
...

I'm still used to starting formulas off with a plus sign to
indicate I
want the cell to be a formula. I think this was one way you
could do it
in old forms of excel. Nowadays all formulas begin with an
equals sign.
If you begin a formula with anything like a + or a - now, excel
automatically puts the = in. Thus you can end up with formulas
beginning =+.

Not sure but I think this is why.


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile:
http://www.excelforum.com/member.php...o&userid=15188
View this thread:
http://www.excelforum.com/showthread...hreadid=477896