how to use the + sign in text

  • Thread starter Thread starter David
  • Start date Start date
D

David

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
 
Either precede it with an apostrophe ('),
or pre-format the cell as TEXT
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

minus signs, or dashes in a formula or hyperlink 3
How to handle a minus sign "-" as text not as part of a formula? 2
-sign 2
How to remove a - sign after the number 9
Putting 0's in Database 2
Excel 2007 - display negative numbers with minus sign and parenthe 3
bingo 5
changing signs in formulas and cells 1

Back
Top