Hi all,
I exported my sales listing to Excel and I got a csv file.
Excel opens correcly my file, but when I wanted to totalise my sales, I noticed that amount decimals are separated by a '.'
My French Excel 2010 is thus unable to detect and SUM my sales amount because it expects ',' as a separator.
Ex : '100,50' instead of '100.50'
I suppose it's a locale problem, but I don't know where to change it without collateral effects on all configuration.
Do you have a trick to correctly export or do I have to modify amounts under Excel ?
Thanks
Regards