I have the following macro code to removes zeros from cells
problem is it also removes zeros if cell has number is example 40.00
Would anyone know how i can fix this ?
problem is it also removes zeros if cell has number is example 40.00
Would anyone know how i can fix this ?
VBA Code:
Sub Delete_zero
Sheets("data").Range("X1:AM20000").Replace "0", "", xlPart
End Sub