Results 1 to 6 of 6

Thread: Problem with imported data table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Wallybok's Avatar
    Join Date
    Oct 2021
    Posts
    3
    Articles
    0
    Excel Version
    2021

    Problem with imported data table

    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!
    Attached Files Attached Files
    Last edited by Wallybok; 2021-10-22 at 12:37 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •