I also have same problem. In one sheet I have numbers from 0 to 15 in column as number but i need to copy that data in other sheet regularly and in other sheet that column is as text because i need leading 0 from 0 to 9 and i am doing it manually,
Please tell me is it possible in any way to get leading zero in text column like 00 , 01, 02 instead of 0, 1, 2 on pasting that data.
I tried some methods but every time when i paste that data so it doesn't add that leading zero.