CSV FILES messing up my prices . " , " problem in the price

When i upload my CSV file for a excel

Data → FROM TEXT/CSV - > import the shopify file

All my prices get multiplied by 100 because it eats my " , "

Can i fix this is shopify some way?

Hello @Dangren ,

Are your prices using a comma as the decimal separator? For example: 9,95 EUR

I think Shopify needs the decimal separator to be a period instead. So replacing 9,95 with 9.95 should fix the problem.

Best,

Daniel

My prices are rounded so i don’t think i configurated a decimal separator. Is there an option to do that in shopify ir this is in the base of my excel?

is

I think Shopify only accepts the period as a decimal separator so you’d need to use the period when you export the file. If you’re still having issues with the price being 100x larger could you attach the first few lines of your CSV?

attached

I selected in excel - the following option and looks like its working