What is purpose of + sign in formula "=+Q290*10"

J

Jim Thomlinson

Yes the plus sign is not required... It was probably entered that was as a
matter of convenience. Instead of typing the equal sign they just typed the
plus. XL inserted the equal sign on it's own.
 
D

Don Guillett

It's a "throwback" to Lotus 123 or sometimes used as a shortcut on the
numeric keypad. Ignore or delete.
 
D

David Biddulph

Yes.
The + is usually a relic of someone who previously used Lotus spreadsheets,
which used + where Excel uses =.
 
Top