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?

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”

Hi @Lori

Try this approach

image

Xaml for reference

AppendRangeWithGeneralFormat.xaml (4.8 KB)

@kumar.varun2
I tested and found your method ok, can you give the reason why I use excel scope failed ?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.