If I want a cell to contain a dash that is not related to subtraction, how can I do this. I formatted the entire worksheet as text, but it still want to use the minus as part of a formula.
Reply from Richard Rost:
Just start the cell off with a single-quote ' character. That will force Excel to treat the cell as text.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel 2010 Beginner 2.
