Formulas beginning with =+

S

Seti

Well-known Member

Joined

May 19, 2002

Messages

2,916

• Jun 13, 2005

• #2

Feel free to get rid of that leading plus sign.

Could be from those who worked in Lotus 1-2-3 where you started a formula with a plus sign generally.

Some use the plus sign to start a formula since you don't have to shift to get the equal sign.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Jun 13, 2005

• #3

The equal sign (=) doesn't require the Shift key.

 

Upvote 0

N

NumberCruncher

New Member

Joined

Dec 21, 2004

Messages

18

• Jun 13, 2005

• #4

equals sign

At least in my home country, Germany, it does. I believe also in other European countries (Italy I'm sure of) the equals sign requires the shift key.

Anyway, thanks!

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Jun 13, 2005

• #5

Interesting. Thanks for the insight.

 

Upvote 0