Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Plus sign (Excel xp)

    How do i format positive numbers with a plus sign + before them. For instance,
    0
    -1
    +3
    -4
    +17
    +2

    Thank you for the help

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Plus sign (Excel xp)

    For XL2000, probably the same in XP, use a custom Number format, with a "picture pattern", like that shown here. Easiest to select one of the predefined ones like +#,##0.00;[ red ]-#,##0.00 (bottom of list in attached graphic) and modify to suit, as shown.

    Alan

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Plus sign (Excel xp)

    ok, thank u very much

Posting Permissions

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