Change cell to positive/negative

[brajah]

Hi. Can you please advise what is the easiest way (by click of a button) to change the sign of the cell. i.e. from a positive value to a negative value.
Thank you.

 

[VoG]

Try like this with a button from the Controls toolbar

Private Sub CommandButton1_Click()
With ActiveCell
    If IsNumeric(.Value) Then .Value = -.Value
End With
End Sub

 

[Gary McMaster]

Another way without using code.

Put the value -1 (minus one) into an empty cell and copy that value to the clipboard.

Highlight the value(s) to be changed

Select Edit > Paste Special

In the paste special dialog select "Values" & "Multiply" and click OK

Gary