How to Change Data Type from 1 to 2 (or vice versa)?

[watsonk1]

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.

 

[JLGWhiz]

See if this helps: https://msdn.microsoft.com/en-us/library/s2dy91zy.aspx

 

[Anand Sharma]

Hi ,

Try using =value() function, it will convert number that have been entered as text.


Need more help? Visit livespreadsheethelp.com for free, instant match, personalized help from paid certified experts in Excel.