How do I place a simple.

I need to place a "-" or a "+" sign in a cell, so that when I save as a CSV file it will still be the same. What happens (even if cell formatted in text) is I get a cell location as if I want to start a formula calulation . The saved CSV shows a -0 for the - sign and a 0 for the +! How can I set up the cell (column) so that I get what I put in it?
Thanks for any help, Don

Note: I tried to do a proper search for this problem, but was hamstrung by not knowing how to form my search.

precede the - or + with an apostrophe (').

e.g. '- or '+

How do I place -

NBVC said:

precede the - or + with an apostrophe (').

e.g. '- or '+

Click to expand...

That works! Thanks, it's probably in EXCEL 101 but I missed it. hwell: