CODEWITHSUNDEEP
excelexport-to-csvdecimal-point
Maxb
Maxb

Reputation: 1

Is there a way to let excel recognize decimal placement?

I've written a csv file with the .to_csv function. This worked fine but when I open the csv file in excel, excel doesn't recognise the decimal placement.

For example:
A number that was supposed to be 100611.52421.. is displayed in Excel as 1006115242123330. I know nothing went wrong with writing the file because when I display the csv file in visual studio code I can see the dot.
Does anyone know how I can properly open the csv file?

Thanks in advance

Upvotes: 0

Views: 215

Answers (1)

Dominique
Dominique

Reputation: 17493

I don't think there's anything wrong with your CSV file. I believe your regional settings are wrong: the dot is not recognised as a decimal separator.
In order to fix this, check the following in your configuration settings:

enter image description here

Upvotes: 2

Related Questions