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

[Dangren]

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?

[Ablestar_Daniel]

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

[Dangren]

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 

[Ablestar_Daniel]

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?

[Dangren]

attached

[Dangren]

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