Getting data from web

Occasional Visitor

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?

1 Reply

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.