View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default + 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