+ or - as text, not math function
On Wed, 5 Nov 2008 17:51:01 -0800, MLM wrote:
When entering + or - alone in a cell, Excell assumes a math function and
enters other characters. How can I get it to accept these as "text" and
leave it that way.
(Formatting as text doesn't work. Entering a ' first does, but doubles
keystrokes.)
Format it as text BEFORE entering the leading plus or minus signs.
Works here (XL 2007)
--ron
|