Keeping Leading Zeros

I have a sheet that I am copying data from to get it in a different format, and the sheet that I am copying from has some data in the form 09, 05, etc. However, when I copy it over, it automatically removes the leading zero. I have tried putting the value in a variable declared as a string, but that doesn't work, either. Any ideas?

Originally Posted by teddybouch

I have a sheet that I am copying data from to get it in a different format, and the sheet that I am copying from has some data in the form 09, 05, etc. However, when I copy it over, it automatically removes the leading zero. I have tried putting the value in a variable declared as a string, but that doesn't work, either. Any ideas?

Yep,
this question has been answered many times on this forum. have a look at " custom format" using 00####

Cheers

Yeah, I searched for this before I posted the question and found the answers you are referring to. The problem is that the column does not always contain an entry that starts with a zero. It could also be all letters like ER, or a misture like 5C. Therefore, I can't simply format the column to have this custom format. In addition, the entries won't always be in the same place, so I can't go through and format specific cells, either. Even if they were, that would be infeasible because there are over 14,000 entries. Any suggestions?

Actually, I was able to solve my problem by formatting all the target cells as text. I was hoping for a non-code solution if I could avoid it - it's already getting a little long. However, the data later gets read into textboxes using a simple assignment:

Please Login or Register  to view this content.

Here it cuts off the zero again. Is there a way to tell the textbox to take it as a string rather than a number?