In article , Bob wrote:
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. :)