Changing a positive number to a negative number...

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Changing a positive number to a negative number...

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I tried using the replace function- but could not figure out how to change a positive amount to a negative amound easily...

    Anyone know a quick way to do this another way?

    Thanks!

  2. #2
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you download the ASAP Utilities add in, there is an option to do just what you are looking for with a couple clicks of the mouse
    Kristy

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    890
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try ASAP utilities

    http://www.asap-utilities

  4. #4
    Board Regular
    Join Date
    Sep 2002
    Location
    Simsbury CT USA
    Posts
    1,551
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    ASAP utilities has a nice feature that does exactly that...

    Free Download ASAP-UTLTITIES


    hope this helps

    pll

    [ This Message was edited by: plettieri on 2002-10-24 12:23 ]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-10-24 12:19, lynneb wrote:
    I tried using the replace function- but could not figure out how to change a positive amount to a negative amound easily...

    Anyone know a quick way to do this another way?

    Thanks!
    1. Enter -1 into an unused cell
    2. Copy the cell containing -1
    3. Select the values you want to change
    4. Paste Special... Values Multiply
    5. Clear cell containing value entered at step 1.

  6. #6
    New Member
    Join Date
    Oct 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Downloading it now

  7. #7
    MrExcel MVP DonkeyOte's Avatar
    Join Date
    Sep 2002
    Location
    Suffolk, UK
    Posts
    9,118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    say numbers in A1 etc...

    B1 = if(a1<0,-a1,a1)


    Does my a$$ look big in this picture ?

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another formula option
    =-ABS(A1)

  9. #9
    New Member
    Join Date
    Oct 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks everyone....! I installed it and wow- gonna save my sanity here


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com