1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Plus/Minus Symbols in Excel

Discussion in 'Business Applications' started by kaktus, Oct 23, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. kaktus

    kaktus Thread Starter

    Joined:
    Oct 23, 2008
    Messages:
    5
    I need to be able to use the plus + and the minus - symbol in excel. Every time I try, it turns it into some sort of formula. How can I make it so that I can actually SEE the symbol and use it as I need it.
    It's for a chart for some special learning students and I need to mark whether or not they are improving or not, and I'd like those two symbols to represent their growth.
    Any help would be appreciated.
     
  2. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,175
    Welcome to the forum. How do you want it to deduce if they need one plus or multiple pluses? How do you want to do the same for minuses? This is kind of vague so you will have to fill you in.
     
  3. kaktus

    kaktus Thread Starter

    Joined:
    Oct 23, 2008
    Messages:
    5
    I don't want it to deduce or add or anything. I just want to view the ACTUAL plus and minus symbol.
    My only other option, which will look kind of lousy, is to just print the darned thing out and WRITE the plus and minus symbol.
    Sorry it was vague.
     
  4. kaktus

    kaktus Thread Starter

    Joined:
    Oct 23, 2008
    Messages:
    5
    Here's a sorta, kinda example:

    Student Growth
    Bob +
    Chuck +
    Sally -
    Susie +
    Billy -
     
  5. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,175
    Are there values that it is comparing so that it places a plus or minus in the cell? This should be easy to do with an If function.
     
  6. kaktus

    kaktus Thread Starter

    Joined:
    Oct 23, 2008
    Messages:
    5
    I agree. It SHOULD be easy. But it is not. I can find nobody who has any idea what I mean, although, I mean something so, very simple. I just want to see the ACTUAL plus or minus symbol.
    There are only words on this paper. There are no values. Even when I try to type a plus or a minus into a blank worksheet, it tells me I'm going to add up some cells.

    I do not want to add. I do not want to subtract. This has nothing whatsoever to do with arithmetic.

    I have found that I can type the symbols into a text document and then copy and paste them into the cells. I suppose that is what I'll have to do.

    Thank you for your attempts to help me.
    Guess I will just have to do it in a word document.
     
  7. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    All you need to do is add ' before any value in your cell. This is a comment symbol, it won't show but anything after it will exactly as is.

    Welcome to the forum.
     
  8. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    Or you can format the cell(s) as text, then enter your data. Other than that MRdNk is right, and it will interpret everything as a formula.
     
  9. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,175
    It should not be interpreting them as a formula unless she types an = beforehand. I just went and verified it and I can indeed type a + without it trying to add anything up. The = sign is what tells Excel to be aware that some sort of computation is about to happen. If for some reason yours is automatically trying to make a formula which it should not then you can comment it out like Mrdnk said.
     
  10. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    Yes, it indeed does interpret that as a formula. It's Excel trying to auto-correct what it thinks you are entering. Try entering this in a cell...

    -Jim

    Notice that #NAME! error? Text as formula, without entering an = sign. Ugh.
     
  11. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Sorry, but even in General format a "+" or a "-" (without the quotes) just sits there. You can't enter -Zack or +Jim without an error, but your example, in which you start out with text identifies the whole cell as a text item.
    So, how are your cells formatted that you are doing this???
     
  12. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    =Bob+ gives and error (as does =Bob+1 or whatever, unless you have a list named Bob).
     
  13. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,175
    I thought Kaktus was trying to have the name in one cell and the plus in another. If you try typing this out it sits as plain text unless you use a leading = to designate it as a fomrula. The standard format is general so it should indeed not be changing it unless she has changed her options.
     
  14. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Well, as I do it, whether it is |Bob+| or |Bob|+|, I get no problems.
    So, unless Kaktus is deriving the name and the outcome (+ or -) from a formula, I don't see a problem either.
     
  15. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    Agreed. That's funny I tested it with Bob, too.
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/762082