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

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

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

Tyro

"Mrs. Rathbone" <Mrs. wrote in message
...
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).