Automatic Negative Column
On Mar 21, 10:38 pm, Mrs. Rathbone <Mrs.
wrote:
Is there a way to "format" a cell so if i enter a positive value, it converts
to a negative amount? No formulas pleez as I cannot insert a column (it's a
financial thing).
If you don't want formulas you'll need a macro, this one should do it:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then ' Change 1 to something else if you don't
want it to check column A.
If Target.Value 0 Then
Target.Value = Target.Value * -1
End If
End If
End Sub
Per Erik
|