Hi,
That depends on what you mean by automatically. You have two solutions from
Jacob, but if you want the value in cell A1 to change as you enter it, from
negative to positive you will need VBA code. For example, suppose you want
this automatic behavior in the range A1:A1000 on Sheet1 then this code will
do it:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Application.Intersect(Target, Range("A1:A1000"))
If Not isect Is Nothing Then
Target = Abs(Target)
End If
End Sub
1. To add this code to your file, press Alt+F11,
2. In the VBAProject window, top left side, find your sheet name under your
file name and double click it.
3. Paste in or type the code above.
