Hi everyone, I am newbie using uipatch and I got a question about pasting value with leading zeros. I have some digits with leading zeros in Excel. Th actual value in excel is ‘0001 so that excel will not convert it into 1. However, when I paste the value by using copy paste range, the leading zeros of the value will be removed when they are pasted into other worksheet. I have a way to solve this by using loop to paste the value by concatenation “‘“ + “00000”.substring(0,5-myvalue.length) + myvalue.tostring. However, the performance is very slow… I tried to read range and keep the format and paste the datatable to another range but no luck.

any smarter solution suggested ?

Thanks everyone!