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
Full knowledgeable Video
Very helpful, Thanks 😊
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
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