CCM2.0 Upload files with decimals in prices

[Former Member]

Hi experts

We use a csv-file to upload into CCM2.0.

We now have a problem when a price in the file is with decimals. We use "," as decimal seperator (100,25 EUR) but we can only upload prices if the decimal seperator is "." (100.25 EUR).

I means a lot of work changing decimal seperators from "," to "." in the file from our vendors

Do anyone have an idea how we can change this - so it is possible to upload prices with "," ?

Thanks in advance

Jesper

[Former Member]

Not really changeable. But it's not that much work to change all the prices.

Open the CSV file in excel and do the following:

1. On the Tools menu, click Options, and then click the International tab.

2. Under Number Handling, clear the Use system separators check box.

3. Type new separators in the Decimal separator and Thousands separator boxes.

Or if that doesn't fit your version of excel, just type "separator" in the help and follow the instructions.

Regards,

Robin

[former_member183819]

Hi Jasper

are you keeping 100 25 in separate column? why?

Are you receiving the Excel file from vendor and making into CSV file ?

csv file can delimit ; instead of ,

if you want to make delimiter set up for the above file

go to control panel ->regional and language options-> click->go to regional option tab-->right hand side you may see customize -> list separator , ( you can change so when you save excel file data into csv file and open a file with notepad mode -> you can see this file in ; instead of ,

br

muthu