Excel sorting data incorrectly

Originally Posted by xlnitwit

That's interesting. As far as I can see, the default settings for Lithuania in Windows are to use a comma as a decimal separator and a full stop as a grouping symbol. Have you changed your regional settings in Control Panel to something else, or have you told Excel to use different ones from your system settings? It looks like The Get and Transform engine is using the full stop as a grouping symbol, not a decimal point.

I have changed the setting in excel, was told to do so on this forum in order to get appropriate data on my other spreadsheet. (not using power query, but simply importing it from web: data>from web)

is there any way to make changes to this get and transform data so it would fit my current settings?
Or what should I do in order to achieve universal solution here?

Originally Posted by xlnitwit

OK, so the issue is definitely your regional settings which is what the PQ engine defaults to using. You need to edit the query to bring up the PQ window, then click the dropdown arrow to the left of the Home tab, choose Options and Settings, then Query options. Now choose Regional Settings in the Current Workbook section, and change it to English (United States) rather than Lithuanian. You should then be able to simply convert any number columns to the relevant type.

Man, thank you very much!!!
This problem has been haunting me for few months and nobody knew the solution to it!

Thank you, this was a tremendous help to me!

Wish you all the best!