Forum Discussion
Need help in importing data from web. Conditional formatting not working on imported data
I am importing data from this link - https://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10006&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentL...
Check the datatype of other columns. They seem to have Text datatype. Edit your query and change the datatype to numeric datatype i.e. Whole Number or Decimals and it should word as expected.
Tried it. But the problem still persists.
