Replacing the 0 by "" in each line until value <> 0

Hello,

I am puzzled with this one.

I have sheet with numerous columns.
Col A - Col B - Col C - Col D - etc
SKU1 - 0 - 0 - 125
SKU2 - 12 - 0 - 14
SKU3 - 0 - 56 - 0
SKU4 - 0 - 0 - 1

I would like to replace all the 0 in a row, starting from the left UNTIL I encounter a value so the above would become (I entered "" where I would like to remove the 0)
Col A - Col B - Col C - Col D - etc
SKU1 - "" - "" - 125
SKU2 - 12 - 0 - 14
SKU3 - "" - 56 - 0
SKU4 - "" - "" - 1

Any idea on how to tackle this one? I am puzzled :/

Thanks in advance
Ludo

Simplist is to use a very simple piece of code:

Select the range and run

Sub replace()

Dim ColCounter As Long, RowCounter As Long

For RowCounter = 1 To Selection.Rows.Count
  For ColCounter = 1 To Selection.Columns.Count
    If Cells(RowCounter, ColCounter) = 0 Then
      Cells(RowCounter, ColCounter) = ""
    ElseIf Application.WorksheetFunction.IsNumber(Cells(RowCounter, ColCounter)) Then
      Exit For
    End If
  Next ColCounter
Next RowCounter

End Sub