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?
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.