Hi Everyone,
i have an issue after write data to new sheet.
-
i have big data and original file is 05678
-
Write to new sheet but result is 5678
-
i have work around :-
3.1 with Conv = “'” + Stringdata.tostring. result is '05678
3.2 Change format cells to text but result is '05678 (i’m not sure it’s original from this activities) -
as i checking before writing data return 05678 with Message box
Expected i need 05678 not '05678
Thank you in advance