Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Show positive numbers with '+' sign

  1. #1
    Join Date
    15th October 2004
    Posts
    66

    Show positive numbers with '+' sign

    A simple one I hope! How do I show numbers, (the result of a simple adding formula) with their + sign?

    I know by formatting the cell to 'text' it shows it, but the number is formulated, and I can't get it to show!

    Help would be soo appreciated!

    Regards

    David

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th July 2004
    Location
    Tokyo, Japan
    Posts
    8,570
    Hi,

    Cell format -> User defined -> type +0;-0;0

    will show + for positive, - for negative, 0 for 0

    hope it helps

    jindon

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th October 2004
    Posts
    66
    works a treat.. Many thanks!

    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. Changing positive numbers to negative numbers
    By Tiffany in forum EXCEL HELP
    Replies: 4
    Last Post: July 16th, 2011, 11:16
  2. Show Plus Sign On Numbers Greater Than X
    By Andy Wild in forum EXCEL HELP
    Replies: 9
    Last Post: August 9th, 2008, 09:54
  3. Display + Positive Sign
    By ravenswood in forum EXCEL HELP
    Replies: 7
    Last Post: May 30th, 2007, 07:58
  4. Display Plus Sign For Positive Numbers
    By Andie in forum EXCEL HELP
    Replies: 6
    Last Post: November 20th, 2006, 17:12
  5. Sum Positive and Negative Numbers regardless of Sign
    By Austin Martin in forum EXCEL HELP
    Replies: 5
    Last Post: July 15th, 2006, 13:57

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