Entering a Text Symbol ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
Click to expand...

'-

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
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 ?
Click to expand...

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. :)
 
Back
Top