? How to make Numbers format with + or - sign

Discussion in 'Mac Apps and Mac App Store' started by Tumbleweed666, Sep 17, 2013.

  1. Tumbleweed666 macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #1
    I want to format some cells, so that if the value is positive, it displays with a plus in front, otherwise it displays with a minus (unless its zero :) as it does now

    So cells that contain say positive 20 or 30, show as +20, +30

    Google searches lead me to believe this cant be done, can anyone show me wrong please?

    TIA
     
  2. Tumbleweed666 thread starter macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #2
    Doh proved myself wrong https://discussions.apple.com/message/10281095#10281095
     
  3. Carlanga macrumors 604

    Carlanga

    Joined:
    Nov 5, 2009
    #3
    which is why you do a search on google first then make a thread :p
     
  4. Tumbleweed666 thread starter macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #4
    I did both.

    Googled, didnt find anything, posted, googled more, found something.

    Its like when you ask your wife "where the hell are my car keys I've been looking for 10 minutes" and she says "right in front of you" :D
     

Share This Page