[RESOLVED] Return as string

[DivinationX]

Hi all,

The value from sheet1's column G should be 00, but when the value in sheet2's column G is 0.

What should i do in order to retain the value as 00?

Please help!!!

Thanks!

e.Rows(d).Value = i.Rows(d).Value

Do Until IsEmpty(i.Range("G" & j))

If i.Range("G" & j).Value = "00" Then
d = d + 1
e.Rows(d).Value = i.Rows(j).Value
End If
j = j + 1
Loop