Forum Discussion

3 Replies

  • When you are retrieving the value, it is returning as text due currency symbol "₹"

    Below formula shall be helpful for you.

    =VALUE(SUBSTITUTE(INDEX(IMPORTHTML("https://www.goodreturns.in/gold-rates/bangalore.html","table",1),2,2),"₹",""))

     

    If this resolves your query don't forget Mark as Solution.

Resources