Question:

In Excel, how do you change a set of negative numbers into positive?

by  |  earlier

0 LIKES UnLike

And vice versa, how do you change a set of positive numbers into negative ones?

 Tags:

   Report
Answer The Question I've Same Question Too

2 ANSWERS

Sort By: Date  |  Rating

  1. Sounds like you're using a function and the result is negative???? Excel uses accounting functions so you have to reverse the result by adding a -sign in your function or formula


  2. multiple them by -1 then copy >  paste special and choose "values" and paste the results back over the original figures.

    ex: =A1*-1

You're reading: In Excel, how do you change a set of negative numbers into positive?

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now
Unanswered Questions