I have treid the following formulas, but it always show $0....555 and not $0.0000555
=TEXT(INDEX(IMPORTXML("https://coinmarketcap.com/currencies/shiba-inu/", "//div[contains(@class, 'priceValue')]"), 1), "$0.0000000")
=IMPORTXML("https://coinmarketcap.com/currencies/shiba-inu/", "//div[contains(@class, 'priceValue')]")
=INDEX(IMPORTXML("https://coinmarketcap.com/currencies/shiba-inu/", "//div[contains(@class, 'priceValue')]"), 1)
How can I getit to show it correct
Perhaps this gets the result you are looking for:
Please Login or Register to view this content.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks