turning a negative into a positive

G

Guest

Hello:

If you have a column of negative numbers, is there an easy way of changing
them all at one time into positive numbers without having to take away the
minus sign to each number individually?

Thanks!

childofthe1980s
 
K

Ken Johnson

Hi childofthe1980s
In any spare cell type -1 then copy that cell, then select the column
of negative numbers, then go Edit, Paste Special and select the
Multiply operation, then click OK.
Ken Johnson
 

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

Turning negative to positive on a mass scale 3
Transform positive numbers into negative 4
Excel - Match positive and negative numbers 9
Converting an invalid negative number to recognizable format? 3
Making a Value in One Column Negative Based on Value in Another Co 1
Numeric Format 3
Help with positive and negative numbers 1
debits and credits in one column 2

Top