Sub MyMacro()
LR = Cells(Rows.Count, 1).End(xlUp).Row
Set rng = Range(Cells(2, 2), Cells(LR, 3))
For Each cl In rng
cl.Value = Replace(cl, "-", "", , -1)
cl.Value = "'" & "0" & cl.Value
Next
End Sub
Sub MyMacro()
LR = Cells(Rows.Count, 1).End(xlUp).Row
Set rng = Range(Cells(2, 2), Cells(LR, 3))
For Each cl In rng
cl.Value = Replace(cl, "-", "", , -1)
cl.Value = "'" & "0" & cl.Value
If Application.CountIf(rng, cl) > 1 Then cl.ClearContents
Next
End Sub
Copyright©1996-2021,Tapuz Media Ltd. Forum software by XenForo® © 2010-2020 XenForo Ltd.