Workbooks.Open macro changes the cell format

I have a an issue... Opening a .xls-file manually, the number formats in the file are with dots such as 1.200 --> As they should.

While opening the same file through a Workbooks.Open macro, it opens the file with the format changed to commas, in this case 1,2 .

My goal is to get all the numbers in the file with over 999 to be in "0"-format , such as 1200 in this case.

This drives me crazy. I feel this should be a simple thing to bypass, but I haven't been able to figure this out.

Any help and workaround & explanation would be much appreciated.

I've added an example file how it opens while opening it manually (with dots).



The system we use can only save the data in .xls or .txt .

I've tried to save the files to .xlsx and .xlsm before opening them through VBA, but still the Workbooks.Open macro changes the cell format when it opens the file.

I attached the file just to give the idea of the original file and format and the goal. I hoped someone could find a macro or solution that helps. This error occurs on opening the file, so there is really no written code to evaluate in this case.