Excel Tip of the Day!
March 16, 2010 – 10:02 amIf you need to put a + (plus, positive) or - (minus, negative) sign in an Excel field, Excel tries to start building a formula. This is cool if you actually want to make a formula, not so much when all you want is the + or -.
You can put an ' (apostrophe) in front of the + or -, like this '- or '+. The ' is Excel's comment character. The ' will not be displayed. The + or - will be.