Change minus numbers to zero in cell

[Bob]

Would anyone know how to change a negitive number back to a(0)in excell.

Thanks Bob

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Don Guillett]

Sub chgnegnumtozero()
For Each c In Selection
If c.Value < 0 Then c.Value = 0
Next
End Sub

 

[Gord Dibben]

Enter 0 in an unused cell.

Copy that.

Select your negative number cells and Paste Special(in place)>Value>OK>Esc.

If you have formulas that return a negative number and wish to preserve the
formulas, change the formulas to something like

=MAX(0,A1-A2)

If A1-A2 is negative, the result will be 0.


Gord Dibben MS Excel MVP

 

[Rusty]

Would anyone know how to change a negitive number back to a(0)in excell.

Thanks Bob

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Assuming the cells contain a formula;
eg =A1-A2
Change the formula to =if(A1-A2<=0,0,A1-A2)

Cheers,
Ken