CSV decimal dot in Excel

For users seeking to this question with newer Excel versions like Excel 365... As written at Professor Excel you could activate/restore "From Text (Legacy)" in the settings.

My prefered solution

File - Options - Data

Other possibilities

At that linked Professor Excel website there are also shown other possibilities. With Excels new import dialog, if you have several columns with numbers all in a different locale to your computers locale settings, then it will be much more effort to do the import. With the old wizard you are set within a minute. With the new import dialog I haven't found yet a method to be as fast as with the legacy import method.

here is the answer I used:

• go to Data tab on excel sheet.

• click on from Text button.

• then select text or csv file.

• then the import wizard will come out. select comma separated or space separated option.

• then select delimiter. (this is better if you don't want it to have problem while importing decimals)

• then in the next window there will be Advanced option for General column type. Click the advanced button and choose how to separate decimals and thousands.

Change the decimal separator to a "." and remove the thousand separator with a space.

1. rename the csv to .txt
2. open excel
3. go to file-->open and point to your txt file
4. go through the steps of importing it
5. make sure to use ; as the delimitter