I tried to create a .csv-file with , instead as ; as list separator (I use a swedish setup). I changed the list separator from ; to , in the Control Panel, but I still get ; as separator when i save the file. Windows 7 RC build 7100 , Excel 2007 SP2 (12.0.6425.1000)

I tried to create a .csv-file with , instead as ; as list separator (I use a swedish setup). I changed the list separator from ; to , in the Control Panel, but I still get ; as separator when i save the file.Windows 7 RC build 7100 , Excel 2007 SP2 (12.0.6425.1000) Saving a file as a comma delimited text file has nothing to do with the control panel; in Excel you select Save As Other and select CVS...unless I'm misunderstanding your question, that is...

According to Microsoft Excel Help documentation a CSV-file is created with "," as delimiter if you have US settings and with ";" if you have European settings. If you want to override this you change the "list separator" setting in Control Panel/region and Language/Formats/Additional Settings. For some reason CSV-files are not the same depending on wich side of the Atlantic you reside. But when you want to upload a contact list to Gmail it has to be in US format. So I changed the setting according to the documentation - but it does not work in Windows 7 /Excel 2007.

The same problem exists in windows XP - maybe it's an Excel 2007 problem?

Found the aswer iin KB Article ID: 266200 SYMPTOMS When you save your file as a Comma Separated Value (CSV) file from Excel, the s... When you save your file as a Comma Separated Value (CSV) file from Excel, the separator (delimiter) that is used is not the character that you chose to be the List separator for your system. When this occurs, you do not receive a warning or error message. CAUSE You chose the same character for both your Decimal symbol and your List separat... You chose the same character for both your Decimal symbol and your List separator in the Regional Settings of your system Control Panel . In this condition, Excel must substitute another character for the list separator to avoid a possible loss of information when the CSV file is saved. WORKAROUND Change either your List separator or your Decimal symbol in the Regional Settin... Change either your List separator or your Decimal symbol in the Regional Settings , so that they are not the same character. To do this, follow these steps: Click Start , point to Settings , and then click Control Panel . Double-click Regional Settings or Regional Options . Click the Number (or Numbers ) tab. In the Decimal symbols list, choose a character that is not the same as your list separator. Alternately, in the List separator list, choose a character that is not the same as your decimal symbol. Click OK . If you are prompted to restart the computer, do so.