View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Using + and / as characters not as functional formatting

you could precede the + and / with a single apostrophe

'+
'/

or use
="+"
="/"


"Bonnie" wrote:

I want to use + and / symbols as text (in a table to designate positive or
negative evaluation), but formatting all cells in the document as 'text' does
not keep Excel from recognizing them as computing functions. Here is the
weird part. If I copy and paste a + or / character from a word document, it
will work, but I can't simply type + or / into the cell. Help???