=+ in formula

Smitty

Legend

Joined

May 15, 2003

Messages

29,536

• May 18, 2006

• #2

It's a throwback to Lotus 1-2-3.

It's unnecessary now and Excel ignores it.

You'll see it a lot in imported Lotus workbooks.,

HTH,

Smitty

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• May 18, 2006

• #3

This is a carry-over from Lotus 123 which required the plus sign.

 

Upvote 0

N

nelsok

Board Regular

Joined

Jan 20, 2006

Messages

166

• May 18, 2006

• #4

thanks

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• May 18, 2006

• #5

In Excel, you start a formula with an equal sign (=). You can also start a formula with a plus sign (+), as you would in Lotus 1-2-3.

If "Transistion formula entry" is checked +ref will be converted to =ref. If not, it'll remain as =+ref

 

Upvote 0