Followed instructions but it wont work....

[talisman77]

I need to convert a column of numbers to the opposite value....Positive to negative and visa versa. I have 480 numbers and would really like to not have to do it manually!!!

Everyone says to put a -1 in an empty cell and then copy it. Then highlight the numbers you want to convert and hit "Paste Special" with radio buttons "value" and "multiply" checked.

I have done that every way I can think of and the only thing I get, is the empty cells filled with a zero.

I am sure it is just a setting somewhere....but where??????

Any help would be greatly apprectiated!

Thanks,
Bob

 

[VoG]

That sounds like you haven't copied the -1 properly so it is multiplying by blank or 0.

Make sure that you copy the correct cell (the one with -1 in it) and try again.

 

[talisman77]

Still nothing......

 

[VoG]

Try selecting the range then running this macro

Sub ChSgn()
Dim c As Range
For Each c In Selection
    c.Value = -c.Value
Next c
End Sub

 

[talisman77]

I apologize a million times over but I don't know how to run a macro

 

[VoG]

Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu then paste the code into the white space on the right. Press ALT + Q to close the code window.

Select your numbers, press ALT + F8, double click ChSgn

 

[talisman77]

Got all the way to Alt + F8....When I did that, nothing happened except the window came up that allows me to adjust my brightness on my screen....

 

[VoG]

Which version of Excel are you using?

 

[talisman77]

2010

 

[VoG]

On the Developer tab click Macros, click on ChSgn then click the Run button.