Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Display Plus Sign For Positive Numbers

  1. #1
    Join Date
    1st April 2005
    Location
    Thailand
    Posts
    145

    Display Plus Sign For Positive Numbers

    If you have a formula lets say (sum A1-A2) and the total is negative i.e. A1 is 100, A2 is 50 would return -50, how do you get the value to show a plus sign if the value is positive? i.e. if A2 is 100 and A1 is 50, excel would simply show 50, but I'd like it to show +50.

    Also, if the result is 0, so both A1 and A2 are 50, how do I get Excel to display the words On Forecast in a cell?

    Thanks in advance

    Andie

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th January 2005
    Location
    Cyprus
    Posts
    2,252

    Re: Automatically Putting A Plus Sign If Number Is Positive

    One possibility would be to use the custom number format. Right Click > Format Cells > Number Tab. By selecting the Custom category you can enter a customised format string in the Type box.

    You would need something like +#;-#;"On Forecast" or if you wanted to show one decimal +#.0;-#.0;"On Forecast".

    HTH
    Carl
    Last edited by Dave Hawley; November 20th, 2006 at 08:57.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    1st April 2005
    Location
    Thailand
    Posts
    145

    Re: Automatically Putting A Plus Sign If Number Is Positive

    Brilliant, thats worked Carl, however, before I applied it the number if greater than a thousand used to display with a comma as a separator and now it doesn't, i.e. it was 1,000, now it's 1000, do you know how I add the , back in?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Automatically Putting A Plus Sign If Number Is Positive

    Use

    +#,###;-#,###;"On Forecast"

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    1st April 2005
    Location
    Thailand
    Posts
    145

    Re: Automatically Putting A Plus Sign If Number Is Positive

    Bingo

    Thanks ByTheCringe2!
    Last edited by Dave Hawley; November 20th, 2006 at 14:52.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    14th January 2005
    Location
    Cyprus
    Posts
    2,252

    Re: Display Plus Sign For Positive Numbers

    ByTheCringe2,
    Thankyou for stepping in,

    Regards
    Carl

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Display Plus Sign For Positive Numbers

    Cheers, each.

    Carl, I learnt a bit doing that!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Count Numbers Of Zeros Before Positive Numbers
    By chrisbrooks72 in forum EXCEL HELP
    Replies: 6
    Last Post: June 22nd, 2008, 16:41
  2. Display Positive Numbers As Negatives
    By ClydeABJ72 in forum EXCEL HELP
    Replies: 2
    Last Post: February 29th, 2008, 11:08
  3. Display + Positive Sign
    By ravenswood in forum EXCEL HELP
    Replies: 7
    Last Post: May 30th, 2007, 07:58
  4. Sum Positive and Negative Numbers regardless of Sign
    By Austin Martin in forum EXCEL HELP
    Replies: 5
    Last Post: July 15th, 2006, 13:57
  5. Show positive numbers with '+' sign
    By aldredd in forum EXCEL HELP
    Replies: 2
    Last Post: October 18th, 2004, 10:40

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno