change 2000 cells (negative numbers) into positive numbers

G

Guest

I have a colum of 2000 numbers (negative) and I would like to have them all
positive. I know I can multiple each number by -1 so it will be positive
(ex: -25 *-1=25) but I do not want to have to do *-1 to each cell, cell
by cell. Is there a way that I can change the sign in one shut?
 
G

Guest

hi Isbern

in an auxliar cell type -1, copy it, select the range when you need to
change the figures, right click, paste special
select values and multiply

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"lisbern" escreveu:
 
H

Harlan Grove

lisbern wrote...
I have a colum of 2000 numbers (negative) and I would like to have them all
positive. I know I can multiple each number by -1 so it will be positive
(ex: -25 *-1=25) but I do not want to have to do *-1 to each cell, cell
by cell. Is there a way that I can change the sign in one shut?
Click to expand...

Are they number constants? If so, Edit > Replace, replacing - with
nothing.
 

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

Change positive to negative number 4
How to change numbers from positive to negative. 2
How to average the last 10 numbers in a row? 9
subtract a positive from a negative 7
Subtracting positive amts from negative and positive from positive 3
How to round negative and positive numbers 6
column of negative numbers into positive numbers 2
Counting consecutive negative value 7

Top