When I was reading data from Excel as a database, I found that the data in Excel is in string format. How do I convert it to a numeric format? Because the query 'WHERE COLUMN > 50' is not working.
To convert to number format select the whole column use keystrokes ctrl+c and then do alt+e+s+v and then press enter and the whole column would change to numeric format
![ผัวเถื่อน - ยูริ โตเกียวมิวสิค [ OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/P08ORRVDGl8/mqdefault.jpg)
When I was reading data from Excel as a database, I found that the data in Excel is in string format. How do I convert it to a numeric format? Because the query 'WHERE COLUMN > 50' is not working.
To convert to number format select the whole column use keystrokes ctrl+c and then do alt+e+s+v and then press enter and the whole column would change to numeric format
@@abhishekarora6136 thanks
Very helpful, Thanks 😊
Full knowledgeable Video
how to create a new sheet in the same workbook using excel as a database ?
It is not possible to create a new sheet using Excel as a database
Thank you
You're welcome