• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I make negative numbers positive

I have several rows of numbers and some are positive and others negative. Is there a formula or Macro that can convert these over to all be positive numbers?

S:AH are the numbers that are both negative and positive and I would like to convert them over into to columns AJ:BO

Thank you all for all your help and wealth of knowledge
 

Attachments

  • MAKE NEGATIVE NUMBERS POSITIVE.jpg
    MAKE NEGATIVE NUMBERS POSITIVE.jpg
    289.2 KB · Views: 2
I have several rows of numbers and some are positive and others negative. Is there a formula or Macro that can convert these over to all be positive numbers?

S:AH are the numbers that are both negative and positive and I would like to convert them over into to columns AJ:BO

Thank you all for all your help and wealth of knowledge


Luke, AMAZING!!!! PERFECT!!! you are GOOD brother!!!

Thank you for such a fast reply
 
Back
Top