[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

[Max]

Either precede it with an apostrophe ('),
or pre-format the cell as TEXT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David" wrote:
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 start of the cell it automatically thinks its a formula,even
after she has changed the formatting to text for the worksheet.

[edvwvw via OfficeKB.com]

David wrote:
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


If you add ' excel will treat the cell as text so enter

'+ John will be shown as + John

edvwvw

--
Message posted via http://www.officekb.com