Columns negative to positive

  • Thread starter Thread starter UniStudent Coll
  • Start date Start date
U

UniStudent Coll

If you have a column of negative and positive numbers, how do you transfer
these numbers all to be positive in the next column?

FC
 
If the numbers in the first column are in A1:A100, then in B1 put the
formula =ABS(A1) and drag it down to B100.

Tyro
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with positive and negative numbers 1
Excel - Adding positive or negative numbers in a column 5
Flipping numeric values 3
Negative Numbers 8
Coloring cells 8
Automatic display positive or negative 3
Chart in Excel 2007- Positive & negative value columns 10
How to convert positive figures to negative ones? 11

Back
Top