Save as CSV isn't saving comma delimited, but is using semi-colon.

C

CCinItly

Save as CSV isn't saving comma delimited, but is using semi-colon... How do I
get it to save using commas only (,)? (I'm using semicolons for other
delimitations and so can't just do a global replace.)

Thanks so much for your help!
 
F

Frank Kabel

Hi
Excel uses your Windows regional settings for saving CSV files. Also ho
should an importing program of this CSV file know whether it is the
list separator or one of your other separators?
 
T

tjtjjtjt

This might be because of your Regional Settings. Go into the Control Panel
for Windows,pick Regional Settings and make sure your list separator is a
comma and not a semicolon.

tj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel: save-as csv : delimiter set to semi-colon, not comma. Why? 1
Files saved as csv files are actually saved as text files? 2
Save as CSV 2
CSV Tab Delimited 4
Workbook.SaveAs method save incorrect CSV file - French XP and Off 7
Question about CSV saving 0
Save file as semi-colon delimited? 2
Save as CSV: extra spaces around commas 2

Top