I am using API in Google Sheets to call prices of cryptocurrencies vrs Bitcoin from URL: https://api.coinpaprika.com/v1/tickers?quotes=BTC
In some cases I am getting scientific notation instead of the x.xxxxxxxx number value. (e.g. Verge coin price (in bitcoin) is currently pulling in 9.4e-7 instead of 0.00000094)
I cannot then do any formula work on the imported data because it is not converting back to the number, and I have so far found no way to convert it or stop it being imported as a scientific number.
I have tried formatting the import cells to text, but that still pulls the scientific number in from the API call (I have contacted coinpaprika support to see if they know a way around it).
What I need is a way to convert that scientific number into x.xxxxxxxx number format so that I can then use it in a formula to calculate the value (in bitcoin) of my holdings in a particular cryptocurrency.