Getting data from web

Highlighted
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
Highlighted

HI @PeterG380 

 

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

 

Capture.PNG

 

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.