View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?

Put an apostrophe to the left of the symbol.

Example: '+

You will see the apostrophe in the formula bar, but not in the cell. The
cell will only show +

Dave
--
Brevity is the soul of wit.


"jools" wrote:

How do you type +, - etc in a cell without Excel automatically assuming that
you want to create a formula?