Query Editor - correcting online data

Hi,
Data imported from Web contains some error and I need to correct these errors. Image is added for better understanding.
image
Would appreciate comments/suggestions from the Forum.

Regards,
AM

can you either upload some data or if you click in (not on) the Error cell it will tell you what the error is

Nick

Enterprise%20DNA%20Expert%20-%20Small

To add to Nick’s comment, I find that most of the time the default “Changed Type” step “creates” the error. However, in fact this helps you to identify any issues with your data, such as comma and dot separated amounts or numeric and alphanumeric ordernumbers in 1 column.

Paul

Enterprise%20DNA%20Expert%20-%20Small