This discussion has been locked.
You can no longer post new replies to this discussion. Posts are automatically locked, when no new replies have been made for a long time. If you have a question you can start a new discussion.

Copy HTML to Excel

In an attempt to copy some data from a table online into Excel something goes wrong.

The table has 5 columns. Name, Amount, Amount2, Prercentage1 and Percentage2. The problem is that all the columns are imported as text. And I need them to be a number.

I used to remember that there was a functions where you could take this amount or percentage and "convert" it into "number". The other problem is that the amount fields are formatted like this: "$0.01" and the percentage fields like "15.15%".  And I can't just ask the provider of the data to change the format! Or natively download it like an excel file!