I have 250 excel files of sec financial data that I am trying to stack into one master sheet of data. However, when I go to do this there is a discrepancy in variable types across the data. For example(hypothetical), column 3 will be the date filed and in some of the files it reads in as numeric and others it will read in as a character variable. This is causing issues whenever I goto stack the files. Any suggestions on what I should do? ... View more