Forum Discussion
SanthoshKumarArutperunjothi10
May 30, 2025Copper Contributor
Unable to take the htmlpage value for formula
Unable to use the htmlpage value for formula
- May 31, 2025
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.
SergeiBaklan
May 31, 2025Diamond Contributor
That's Google Sheets question, isn't it?
- Jun 04, 2025
yes, that for google sheets.