Entering a Text Symbol ?

[Bob]

Hello,

I wish to have the character "-" in the middle of a cell to signify 'do
not use this cell'

I thought all I would have to do is format it first as Text, and then I
could enter the -

But apparently not.

How should I do this, please ?

Thanks,
Bob

 

[GS]

Hello,

I wish to have the character "-" in the middle of a cell to signify
'do not use this cell'

I thought all I would have to do is format it first as Text, and then
I could enter the -

But apparently not.

How should I do this, please ?

Thanks,
Bob

'-

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[noydb]

Hello,

I wish to have the character "-" in the middle of a cell to signify 'do
not use this cell'

I thought all I would have to do is format it first as Text, and then I
could enter the -

But apparently not.

How should I do this, please ?

1) suggest you use a text string (like "dont use") instead of a "-" (which has
other implications ).
2) if you must use a -, try entering a single quote before it so that it looks
like ...

'-

' means this is text.

Good luck.

 

[Ron Rosenfeld]

Hello,

I wish to have the character "-" in the middle of a cell to signify 'do
not use this cell'

I thought all I would have to do is format it first as Text, and then I
could enter the -

But apparently not.

How should I do this, please ?

Thanks,
Bob

What happens when you try? What do you expect to happen?

In Excel 2007, I have no problem entering the hyphen into a cell, no matter if it is formatted as TEXT or as General, and also "center aligning" the hyphen.