Forum Discussion

Copper Contributor

Sep 15, 2019

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...

excel

SergeiBaklan

Diamond Contributor

Sep 15, 2019

chandragoku

I see on you screenshort that these columns are formatted as text. You tried to convert to numbers and still have texts or you tried something else?

n 2010 perhaps similar query returned numbers, not text.

chandragoku

Copper Contributor

Sep 15, 2019

SergeiBaklan

Well, if I am formatting the data into number after loading the table then it is not working. Albeit, if I am formatting it in power query editor before loading it on spreadsheet then it is working. Seems like a solution was found. Thanks alot.

Subodh_Tiwari_sktneer
Silver Contributor
Sep 15, 2019
chandragoku
That's what I suggested and maybe you didn't pay attention to what I was suggesting.
SergeiBaklan
Diamond Contributor
Sep 15, 2019
chandragoku

If you in Excel just format cell from text to number, the value of the cell won't be converted from text to number even if text has number representation. You need to re-enter value, or use VALUE()/--, or some other methods to convert, depends on situation.