Changing a group of neg #'s to positive #

  • Thread starter Thread starter Sonia Rokusek
  • Start date Start date
S

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





.
Click to expand...
 
Back
Top