Column C has numbers downloaded in text format, i.e. each cell has a green smart tag and a value might be 000 or 001. In Column A, when I refer to column C in a concatenation, the 001 is showing in column A as 1. So the number as text is being converted to a number format after the concatenation is applied. Rather than having this, I would like to retain the values in Column C as is, i.e. 000 should stay as 000 and 001 should remain 001 when they appear in column A.

I forgot how to do this.


Initially I tried to start by retaining the values in column C as follows.

ActiveWorkbook.Worksheets(1).Columns("C") = Worksheets(1).Columns("C")