Excel, change column of negative numbers to positive numbers?

Discussion in 'Microsoft Excel New Users' started by Nita, Nov 27, 2007.

  1. Nita

    Nita Guest

    If I need to quickly change an entire column (800 rows) of negative numbers
    to positive numbers, what is the easiest way. I tried the paste special
    multiply by -1, but it didn't work, I'm probably doing it wrong.
     
    Nita, Nov 27, 2007
    #1
    1. Advertisements

  2. Nita

    JMB Guest

    If your data is in A1:A10 and -1 is in B1, then copy B1, select A1:A10 and
    click edit/paste special/multiply.


    "Nita" wrote:

    > If I need to quickly change an entire column (800 rows) of negative numbers
    > to positive numbers, what is the easiest way. I tried the paste special
    > multiply by -1, but it didn't work, I'm probably doing it wrong.
     
    JMB, Nov 27, 2007
    #2
    1. Advertisements

  3. Nita

    Gord Dibben Guest

    If the copy and paste special>multiply did not work, perhaps your numbers are
    not "numbers" but text.

    In an adjacent colukmn enter =ISNUMBER(cellref) and copy down a few rows.

    Do you get TRUE or FALSE?


    Gord Dibben MS Excel MVP

    On Mon, 26 Nov 2007 18:12:01 -0800, Nita <> wrote:

    >If I need to quickly change an entire column (800 rows) of negative numbers
    >to positive numbers, what is the easiest way. I tried the paste special
    >multiply by -1, but it didn't work, I'm probably doing it wrong.
     
    Gord Dibben, Nov 27, 2007
    #3
  4. Nita

    JMB Guest

    I tried the copy/paste special on text values already, but the copy/paste
    special worked for me. Even when the text values were the result of formula,
    excel added *-1 to the end thereby coercing the text values to numeric.

    "Gord Dibben" wrote:

    > If the copy and paste special>multiply did not work, perhaps your numbers are
    > not "numbers" but text.
    >
    > In an adjacent colukmn enter =ISNUMBER(cellref) and copy down a few rows.
    >
    > Do you get TRUE or FALSE?
    >
    >
    > Gord Dibben MS Excel MVP
    >
    > On Mon, 26 Nov 2007 18:12:01 -0800, Nita <> wrote:
    >
    > >If I need to quickly change an entire column (800 rows) of negative numbers
    > >to positive numbers, what is the easiest way. I tried the paste special
    > >multiply by -1, but it didn't work, I'm probably doing it wrong.

    >
    >
     
    JMB, Nov 27, 2007
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    negative numbers to positive numbers in excel

    Guest, Nov 8, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    1,131
    Niek Otten
    Nov 8, 2004
  2. chom

    Compare Negative & Positive Numbers

    chom, Jul 28, 2005, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    456
  3. George

    Change negative amount to positive.

    George, Jul 29, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    315
    George
    Jul 29, 2005
  4. Guest

    Excel Positive/Negative Running Total

    Guest, Mar 22, 2007, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    401
    Pete_UK
    Mar 22, 2007
  5. Guest
    Replies:
    4
    Views:
    447
    Guest
    May 27, 2007
  6. Guest

    Changing positive values to negative

    Guest, Jul 6, 2007, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    334
    Guest
    Jul 7, 2007
  7. Guest

    How do I make a column formatted for only Negative Numbers?

    Guest, Sep 3, 2007, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    631
    Guest
    Sep 5, 2007
  8. robbin
    Replies:
    1
    Views:
    320
    Niek Otten
    Jun 17, 2008
Loading...