Text Import Wizard issues

fedemarinozzi 

In Microsoft Windows, click Start, and then click Control Panel.

Open the Change Regional and Language Settings dialog box.

Enter a new separator in the List Separator field.

Click OK twice.

Does it work?

Import or export text (.txt or .csv) files

https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba?ui=en-US&rs=en-US&ad=US#bmimport_data_from_a_text_file_by_conne

No?

then try this please.

https://answers.microsoft.com/de-de/msoffice/forum/all/dezimaltrennzeichen-in-csv-datei-korrekt/48b98267-2744-459f-adc8-4bc53c2e8a17

(Link is in German)

Create your query.

The 0 before the decimal point is gone. Right click on the query => Edit.

Then click in the editor in the column header of the corresponding column => change type => text. Repeat for the next column.

The 0 is now available again. However, the cells are then formatted as text.

You can then either replace the point with a comma via Find & Replace or with data => text in columns => fixed width and then in the 3rd step of the assistant under "More" change the decimal separator to point.
Then your query will have decimal numbers separated by commas.

However, both columns are then reset to text with each update.
You can get around this by inserting data as values into another sheet.

Thank you for your patience and time.

Nikolino

I know I don't know anything (Socrates)