Excel export amount separator

  • Posts: 190
  • Thank you received: 0
11 years 11 months ago #73967

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

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 11 months ago #74132

Hi,

I think that you can find your answer in this thread:
www.hikashop.com/en/forum/4-how-to/31648...arator-qq.html#31648

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum