Positive to Negative

  • Thread starter Thread starter Connie
  • Start date Start date
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
 
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)
 
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.
 
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





.
Click to expand...
 
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)





.
Click to expand...
 
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
 
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.
 
hi sabine

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

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