Exporting to CSV-format using comma instead of Semicolon

Jan Hoffmann

New Member
Joined
Jun 27, 2007
Messages
17
Hello Everybody,

I have an Excel-sheet, which I want to save as csv-format. I need the columns to be delimited by comma, however when I save the file as a csv-file, the columns are delimited by semicolon instead. How can I change this?

Thank you in advance.

Best regards

Jan Hoffmann
 

zac_fozz

New Member
Joined
Jan 5, 2010
Messages
6
I could be a problem with your Windows Regional and Language settings. Goto Start -> Control Panel -> Regional and Language Options -> On the "Regional Options" tab, click the "Customize" button. -> On the "Numbers" tab, you'll see a field for "List separator"

If it has a semicolon in it, then that is probably your problem. Change it to a comma. If that doesn't do it, let me know and I'll think about it some more.

(When I changed mine from a comma to a semicolon, then created a CSV file, it created it with semicolon delimiters.)
 

hitch75

New Member
Joined
Jan 27, 2011
Messages
2
Hello!

I have exactly the same problem. Instead of a comma, I get a semicolon, and it is only happening since a few weeks ago! Before that, it always used to come out with a comma. I don't remember changing anything that could have caused this.

I followed your advice zac_fozz, and I found out in my regional settings the "List separator" was really a semicolon, so I changed it to a comma, hoping that the problem was solved, but unfortunately nothing changed!! :(

Any more ideas? What else could be causing this??
 

zac_fozz

New Member
Joined
Jan 5, 2010
Messages
6
Any more ideas? What else could be causing this??
No, I'm sorry. I don't. I know this sounds basic, but I would try restarting your computer after making (and applying) the change to your regional settings, then checking to make sure the change is still there.

The fact that when you looked in your "List separator" settings and there was a semicolon instead of a comma says to me that it probably is the problem. Maybe the change didn't take.

That's all I've got.
 

hitch75

New Member
Joined
Jan 27, 2011
Messages
2
No, i've done that; restarted the pc, checked if the change is still there, it is - it's comma now, but excel still uses a semicolon for csv!!:eek:

thanks for your help anyway

If anyone has any idea idea.... would be nice
 

Forum statistics

Threads
1,081,556
Messages
5,359,548
Members
400,533
Latest member
fpenning

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top