Getting data from web

[PeterG380]

I  getting data to excel using "get data" and from web-page. I select a table. When a number is over 1000 it will reject the ending zeros, e.g. 970 will be ok but 3,700 will be 3,7. Wy? Can i also chane the "," to space?

[#2]

HI @PeterG380 

Please check your datatype might be text that could be reason it in not filtering 

attached is the sample file for your reference. 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

[#3]

If you find the above solution resolved your query don't forget mark as Official Answer.