View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default how to use the + sign in text

a friend is trying to type in 2 names into a cell. The first name will have a
+(plus) infront of it and the second will have a -(minus) infront of this.
She then wants to be able to colour all the minus names. As soon as she puts
the + at the stasrt of the cell it automatically thinks its a formula,even
after she has changed the formatting to text for the worksheet.

Any help appriciated

Regards