Two Excel have same columns and cell format, while use append range, the second excel “invoice date” change from General to Date, how to solve this issue?
I want to still keep General format.
B1_TestUse.xls (28 KB)
A1_TestUse.xls (28 KB)
append excel.xaml (7.7 KB)
Remark: I need to append “B1_TestUse.xls” into “A1_TestUse.xls”