Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Changing positive numbers to negative numbers

  1. #1
    Join Date
    8th February 2005
    Posts
    72

    Changing positive numbers to negative numbers

    I am working with an automatic download. Some of the numbers should come across as negative but they are not. I can tell by a code in another column which should be negative. I can sort this column and see which should be negative. Is there an easy way to make these negative, besides going in to each cell and adding a - sign? There are thousands of numbers!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Changing positive numbers to negative numbers

    Hi Tiffany,

    Use a single helper cell, in that put -1. Copy the cell and then select all the cells that require negating.
    Use paste special - Multiply

    Cheers
    Andy


  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,337

    Re: Changing positive numbers to negative numbers

    Hi Tiffany,

    Or..

    =ABS(A1)

    Sorry! Discard this post.

    ABS changes the negative to positive value.

  4. #4
    Join Date
    8th February 2005
    Posts
    72

    Re: Changing positive numbers to negative numbers

    Andy,

    Thanks! That worked. Should have thought about that....

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    16th July 2011
    Posts
    1

    Re: Changing positive numbers to negative numbers

    Thank you Andy, that really worked and saved me a lot of time !

    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. Convert Positive Numbers To Negative
    By Markw in forum EXCEL HELP
    Replies: 5
    Last Post: January 9th, 2008, 18:47
  2. Color Code Positive & Negative Numbers
    By Chad Thomas in forum EXCEL HELP
    Replies: 2
    Last Post: June 28th, 2007, 12:48
  3. Sum Positive and Negative Numbers regardless of Sign
    By Austin Martin in forum EXCEL HELP
    Replies: 5
    Last Post: July 15th, 2006, 12:57
  4. Negative numbers to positive
    By wsim in forum EXCEL HELP
    Replies: 10
    Last Post: April 1st, 2006, 04:50
  5. Storing positive numbers as negative
    By zed_raz in forum EXCEL HELP
    Replies: 5
    Last Post: March 24th, 2006, 11:24

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