How I can change negative values automatically to positive.

Either use the function
=ABS(A1)

OR

Type -1 in a cell
Copy that cell
Select the range of negative values
Right clickPaste special
Select Multiply. and click OK

will convert all to positive numbers

If this post helps click Yes
---------------
Jacob Skaria


"Maribel" wrote:

How I can change negative values automatically to positive.

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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Maribel" wrote:

How I can change negative values automatically to positive.