I have two excel files. They contain headers like date, balance qty etc. When i append contents of second file to first file by copy pasting values to end of first file, some columns like balance get converted to random dates.
This does not happen if i append the first file to the second file. What can possibly cause such errors?