Automatic Negative Column

[Mrs. Rathbone]

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

 

[Per Erik Midtrød]

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

 

[Tyro]

What does "format" mean? Show positives as negatives and negatives as
positives without actually changing the cell values? If so, use custom
formatting.

Tyro