import error

[octo1212]

i'm attempted to import data into Excel using the "get and transform data" "from web" function...
it's working, but there is a slight problem: it's converting numbers into abbreviated numbers, e.g. "$6,123,456" on the website is imported as "$6.123 M" in Excel...
i can't use simple math functions with numbers that are listed as "$6.123 M"...
any thoughts?
the website is coinmarketcap.com...they have a publicly available API, but i'm not sure how to interface it with Excel...

[sandy666]

is that what you want?

(change columns order if necessary)

[octo1212]

thanks for the help!
almost...the letter designation M for millions and B for billions is missing...so the number is not meaningful or useful in any formulas i would use...i'd prefer the numbers to be the actual numbers on the site...
so for the first line, it should be Bitcoin with a market cap of 169059547718...not 169.82 B and not 169.82...
i want to be able to manipulate the numbers with SUM and other simple multiplication formulas...

[sandy666]

I removed M and B so you can change M to 000000 or whatever and B to ..... or split column to number and letter(s) then if column with M contain M then column with number * 1000000 and so on
titles on the site arent the same as in table but on the end you can change headers suitable

remove all $ sign because in PQ $ and number is a text not a number. you can add this sign later to the result table (currency format)

[octo1212]

i just want to import the data and not have to change 1500 cells manually...why is it importing 169059547718 as 169.82 B?

[sandy666]

Who said you must change it manually?????
in PQ is option Replace Values

[sandy666]

Here is a proper version (I hope)