Clearcontesnts not working as expected.

So I have a piece of code from a macro that works perfectly in another workbook.
Now I copied that code in my new workbook but the outcome is not as in the original workbook.

This is the code:

Please Login or Register  to view this content.

Now in the original it indeed cleared the contents. Totally empty.

However in the new book it cleares the contents but it shows a 0 (zero)....not what i want.
Also try in the settings to uncheck "show 0 when value is zero".
Indeed the cell looks empty but when you select the cell you still see the 0.....

As said in the original workbook this was not the case. Totally empty also when the cell was selected.

Anybody know what is going on?
Thanks.

Hope this Helps, Change the Range Accordingly.

Dim lprow3 As Long
With ActiveSheet
lprow3 = .Cells(.Rows.Count, "A").End(xlUp).Row
End With
For k = 2 To lprow3
If Range("E" & k).Value = "EUR" Then
Range("AB" & k).ClearContents
End If
Next k

Thanks but same result.
And probably I could have te zeros afterwards delete again....

But the point of this all is that the code works in one workbook and changes in another workbook the contents of the cell to 0 instead of cleaning it.
Apart from finding this anoying I also would like to understand what could cause this behaviour in excel.

Well I found it......

It was a piece of code after the clearcontents that caused to show zeros.
The code made absolute values of the cells in that column (ABS).....so that caused to show zeros after it was clearcontentst.... woops...