export import article

I did put this question also in general ..... But i thought it would be better to put it in here.
Hello,

When i do an export of the articles, i see a column price_value. I have everything in euro.
In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro.

And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro.

With regards,

Guido

I opened your CSV file on my end and the price is 4 not 400. It must come from a problem with your CSV editor.
I'm using libreoffice's calc on my end and the price is fine.

Nicolas,

You're right.
I attach both files, one with librecalc and one with excel.

Strange that they behave different, i will use librecalc for the export and import from now.

With regards,

Guido

That's strange as we also tested it with excel and other users are using excel too.
Not sure why though but it if works with calc it must be something coming from excel.