turning a negative into a positive

C

childothe1980s

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

Top