Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If Target.Value > 0 Then Target.Value = Target.Value * -1
End If
End Sub
Simply format them as -0.00
Hello,
Select the whole column, then select FORMAT --> CELLS, choose CUSTOM and enter -0.00.
This will format numbers entered as negative with two - symbols though.
Hello,
Select the whole column, then select FORMAT --> CELLS, choose CUSTOM and enter -0.00.
This will format numbers entered as negative with two - symbols though.