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?