change 2000 cells (negative numbers) into positive numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lisbern - 16 Aug 2006 17:42 GMT

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?

Reply to this Message

Marcelo - 16 Aug 2006 17:48 GMT

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

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> 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?

Reply to this Message

Harlan Grove - 16 Aug 2006 17:54 GMT

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?

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

Reply to this Message