I am trying to convert an excel file to a csv file.  The resulant file
is ; separated, not , separated, and the program that is reading wants
it to be , separated only...what am I doing wrong?

---

Request for Question Clarification by denco-ga on 13 Aug 2005 17:02 PDT

Howdy fgrell,

I would like you to try to following and see it works for you please.

- Close Excel
- Click Start
- Click Settings
- Click Control Panel
- Click Regional and Language Options
- Click on Customize
- Make sure the Decimal symbol is a period and change it to one if it isn't
- If the List separator is a semicolon (;) change it to a comma
- Run Excel and save the file as a CSV file

If the above works for you, please report back here and I can then post the
above as an answer.  Thanks!

Looking Forward, denco-ga - Google Answers Researcher

---

Clarification of Question by fgrell-ga on 13 Aug 2005 18:43 PDT

denco,

That was the problem!  I should have suspected as much..as we set the
computer to french language...who knew that that would change the
separator!  Thanks for the quick response...

Howdy fgrell,

Glad the following worked to solve your problem.

- Close Excel
- Click Start
- Click Settings
- Click Control Panel
- Click Regional and Language Options
- Click on Customize
- Make sure the "Decimal symbol" is a period and change it to that if not
- If the "List separator" is a semicolon (;) then change it to a comma
- Run Excel and save the file as a CSV file

Excel works off the "universal" settings for your computer, so if it is
set, as was in your case, to a non-U.S. setting, it might be set to use a
semicolon as the separator in files saved out in CSV format.

If you need any clarification, please feel free to ask.


Search strategy:

Google search on: Excel "save as" comma delimited semicolon
://www.google.com/search?q=Excel+%22save+as%22+comma+delimited+semicolon

Looking Forward, denco-ga - Google Answers Researcher

Fgrell --

All that remains is to tell Denco-GA to submit the instructions as an
Answer.  Otherwise they don't get remunerated.

Best regards,

Omnivorous-GA

Thanks for the 5 star rating, fgrell-ga.

Looking Forward, denco-ga - Google Answers Researcher