Wallybok
New member
- Joined
- Oct 22, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2021
Hi there! I'm struggling with with a data table I created and I can't seem to get around my issue...
Basically I pulled from the web a table containing all the cryptocurrencies with their price which will update in real time.
The price is is USD but I needed to be in Euro.
To solve this I imported another table with real time exchange rate EUR>USD.
I just wanted to multiply the USD value of the cryptocurrency table with the exchange rate value obtaining in another column the value in euro.
It doesn't work...I suspect is because the price value of the cryptocurrency has the $ symbol in front of the number so the formula won't work.
How do I get around this?
Attached the file I'm using.
Thanks in advance!
Basically I pulled from the web a table containing all the cryptocurrencies with their price which will update in real time.
The price is is USD but I needed to be in Euro.
To solve this I imported another table with real time exchange rate EUR>USD.
I just wanted to multiply the USD value of the cryptocurrency table with the exchange rate value obtaining in another column the value in euro.
It doesn't work...I suspect is because the price value of the cryptocurrency has the $ symbol in front of the number so the formula won't work.
How do I get around this?
Attached the file I'm using.
Thanks in advance!
Attachments
Last edited: