[RESOLVED] Return as string

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!

Code:

---

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

---

Set the cell format of that column to "00"

Hey pradeep, many thanks for your assistance, managed to solve it. :)