Positive to Negative

[Connie]

How do I convert a column of numbers from positive to
negative?

 

[JulieD]

Hi Connie

two ways

1.
type -1 in a cell somewhere & copy it
select your range and choose edit / paste special multiply
click Ok

2.
select your range
choose format / cells
choose custom
type a "-" in front of the formatting shown on the right hand side

hope this helps

Cheers
JulieD

 

[Dave R.]

Put a -1 in a cell, copy it, select your range, go to edit>paste
special>multiply.

Note - this will also turn negatives into positives.

For a formula you can use a helper column with;

=IF(A1<0,A1,A1*-1)

 

[Norman Harker]

Hi Connie!

Put -1 in a cell
Copy
Select the data to be converted
Edit > Paste Special > Multiply
OK

But note that will convert negatives to positives as well and they may
not be what you intend. In that case you'll need a helper column and
use the formula:

=if(A1<0,A1,A1*-1)

That will retain existing negatives.

You can then select your formulas and use

Edit > Paste Special > Values > OK

And existing data can be deleted.

 

[Guest]

Thank you!

-----Original Message-----
Hi Connie

two ways

1.
type -1 in a cell somewhere & copy it
select your range and choose edit / paste special multiply
click Ok

2.
select your range
choose format / cells
choose custom
type a "-" in front of the formatting shown on the right hand side

hope this helps

Cheers
JulieD





.

 

[Guest]

Thank you!

-----Original Message-----
Put a -1 in a cell, copy it, select your range, go to edit>paste
special>multiply.

Note - this will also turn negatives into positives.

For a formula you can use a helper column with;

=IF(A1<0,A1,A1*-1)





.

 

[Peo Sjoblom]

Note that the second option won't change the numbers, only the display

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Dave R.]

Norman, I must say your thoughts on this matter are most brilliant

 

[Norman Harker]

Hi Dave!

Almost the same as yours; only more words

 

[Sabine]

I use this one alot:
try copy the whole range of numbers, then paste special
value, subtract. This will make a positive number into a
negative number or a negative number into a positive
number.

 

[JulieD]

hi sabine

what version are you using as i get 0 when i try this? (ver 2003)

regards
JulieD

 

[JulieD]

Oh okay it works if you paste special it to another location, not over
itself which i was doing at first ...