I am using Power Query in Excel and am getting data type errors. I have 34 source tables that I have appended into one query. The data from one table in the appended query gives a data type error on one column, saying that it can't convert the data to a number, even though it is set as text. The query for that table and column is set to text and gives the same error. The source table column is formatted as text. Even new data entered into the source table gets the same error. Please help! There are no special symbols or numbers in the source data.
I have attached some of the Excel sheets I'm working with. The 2020 Monthly Haul Sheet is one of the source files (August_2020 is the table with problems), and the MTR Report - NEW is where the query is. I can send the other two source sheets, if needed.