Changing a group of neg #'s to positive #

[Sonia Rokusek]

I have had great success on these message board answering
questions that I have. I don't seem to see a similar
issue this time.

I have a group of numbers across 6 worksheets that need to
have the signs changed from negative to positive. Does
anyone know a quick way to do this?

Thank you in advance.
Sonia

 

[JS]

using ABS formula will do it

=ABS(A1) and drag down for all cells

 

[Dan E]

Here's a short little macro to do it

Sub Macro1()
For Each c In Selection
c.Value = -c.Value
Next
End Sub

Just select a range and run this macro it'll change the sign of each cell.

Dan E

 

[Paul Corrado]

Sonia,

Place the value -1 in your worksheet.

Select that cell and Edit/Copy

Select the range of cells for which you want to change the sign

Edit/Paste Special and select the Multiply Operation

HTH

PC

 

[Paul Corrado]

Dan,

I've had similar experiences. This place is a real eye opener isn't it.

PC

 

[Sonia Rokusek]

Thank you so much! Worked great!

-----Original Message-----
Sonia,

Place the value -1 in your worksheet.

Select that cell and Edit/Copy

Select the range of cells for which you want to change the sign

Edit/Paste Special and select the Multiply Operation

HTH

PC





.