Can't fix data formatting

[MuTako]

Hello everybody,
i have two PCs with two different excel and Windows versions.

Machine 1:
Windows 10 Enterprise
MS Office Pro 2019
File looks like that:

artikel_menge;"rechnung_empfaenger_firma";"rechnung_empfaenger_uid";"rechnung_empfaenger_anrede";
16,0000;;;;;;;;;;;;;"132	05";"145	40";"13	35";"20
1,0000;Go;5564;"Herr";;"Heiko";;;;;"222432";;;"78	33";"94	00";"15	67";"20

Machine 2:
Windows 10 Pro
Microsoft 365 Apps for business
File looks like that:

artikel_menge	rechnung_empfaenger_firma	rechnung_empfaenger_uid	rechnung_empfaenger_anrede
16
1	Go	5564	Herr

So my question is how can i fix the formatting on the first PC, so it looks like in the second one.

[vba_php]

from the 1st image:

the first line should be easy because it is delimited by a common symbol. the 2nd and 3rd lines however, have no correlation between the images whatsoever. but, if one looks deep enough, one could probably tell what you are getting at. the difference between line 2 and line 3 between image 1 and image 2 make good sense.

I'm not an interface expert, but they *are* around here. line 2 and 3 might be more difficult, however for line #1, this should suffice:

https://www.google.com/search?q=exce...delimited+text

[6StringJazzer]

You are opening a comma-delimited file, but it is actually delimited with ";" instead of ",". This is a regional setting. I am guessing that Machine 2 is configured for European settings and Machine 1 for something else (maybe U.S.). When I open the file I get results like Machine 1, because I use U.S. settings.

To change the settings in Windows 10 for Machine 1:
1. Go to Control Panel (not Settings)
2. In Region section, click on Change the date, time, or number formats
3. Click on Additional settings button
4. Type a semicolon in the List separator box to replace the comma
5. Confirm the change

[MuTako]

vba_php thanks for your answer. I've uploaded the wrong file and now i've changed it with the right one.
I don't want to edit the file, i just want it to look properly upon opening. It seems there are some regional settings messed as suggested in the post after yours

6StringJazzer
I was assuming there's something going on with the regional settings, tried comparing the settings, but i couldn't figure out what's the problem. I've changed what you have pointed out and it definitely looks better now. (although the line separator for both machines was the standard comma).
The only thing left is that now the zeroes are not ignored and the number on column A is shown as 160,000 (machine 1, where i changed the List separator).

Here's a picture of the settings and how the data looks now:

[vba_php]

It seems to me that the other person who replied to you knows a little bit more about the global nature of the program and its distribution. So best to work with him

[6StringJazzer]

I will have to do a little more research on this. There may be settings in Excel as well as Windows. The separator is one issue, and the other seems to be that now after making that change it is seeing

16,0000

as

160000

instead of

16 [decimal] 0000

I use strictly U.S. settings so I don't have experience with the problem you are having but I'll see what I can dig up.

[GeoffW283]

I will have to do a little more research on this. There may be settings in Excel as well as Windows.

In Excel: Ribbon > File > Options > Advanced > Editing Options there's a checkbox for "Use system separators" If you uncheck that then you can specify what decimal separator and thousands separator to use. Maybe try changing decimal separator on the US machine to "," - just a thought - not tested!

[MuTako]

In Excel: Ribbon > File > Options > Advanced > Editing Options there's a checkbox for "Use system separators" If you uncheck that then you can specify what decimal separator and thousands separator to use. Maybe try changing decimal separator on the US machine to "," - just a thought - not tested!

I tried that, didn't help.
It just shows the number as : 160.000

[MuTako]

Thank you, i really appreciate the effort!
If you need any information from my side, i will be more than happy to assist!