Hi Everyone,
I have been trying to join two Excel tables with a Microsoft Query and kept getting the "Type mismatch in expression" error because my data is different types. I tried using Ctrl + 1 to format the cells (text/ general/ number, etc.) but kept getting the error even if they appeared to be the same type. Finally I tried the =TYPE function and found that they are not actually the same type; one is 1 (NUMBER) and the other is 2 (TEXT). I cannot figure out how to change one of the tables to make them the same type! Can anyone here help?
I am in Excel 2010 and I do not have PowerPivot, if that makes a difference (my Google searches make me think it might).
Thank you all, as always.
I have been trying to join two Excel tables with a Microsoft Query and kept getting the "Type mismatch in expression" error because my data is different types. I tried using Ctrl + 1 to format the cells (text/ general/ number, etc.) but kept getting the error even if they appeared to be the same type. Finally I tried the =TYPE function and found that they are not actually the same type; one is 1 (NUMBER) and the other is 2 (TEXT). I cannot figure out how to change one of the tables to make them the same type! Can anyone here help?
I am in Excel 2010 and I do not have PowerPivot, if that makes a difference (my Google searches make me think it might).
Thank you all, as always.