Quote Originally Posted by xlnitwit View Post
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!