Results 1 to 9 of 9

Changing a positive number to a negative number...

This is a discussion on Changing a positive number to a negative number... within the Excel Questions forums, part of the Question Forums category; I tried using the replace function- but could not figure out how to change a positive amount to a negative ...

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    3

    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, Administrator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    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

    Default

    Try ASAP utilities

    http://www.asap-utilities

  4. #4
    Board Regular
    Join Date
    Sep 2002
    Location
    Simsbury CT USA
    Posts
    1,542

    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

    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

    Default

    Thanks Downloading it now

  7. #7
    MrExcel MVP DonkeyOte's Avatar
    Join Date
    Sep 2002
    Location
    Suffolk, UK
    Posts
    9,113

    Default

    say numbers in A1 etc...

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


    Does my a$$ look big in this picture ?

  8. #8
    IML
    IML is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,744

    Default

    Another formula option
    =-ABS(A1)

  9. #9
    New Member
    Join Date
    Oct 2002
    Posts
    3

    Default

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


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