Columns negative to positive

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
 
T

Tyro

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

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

Top