Change of field separator in csv files (comma separated)

[Jens Pedersen]

Hi

For some reason I get semi-colons instead of commas as field separators when
I save an Excel sheet as a csv file. I am using english versions of
Windows2000 and Excel2000 but on a PC configured with danish regional
settings. Any idea how I can change the field separator to a comma??

/Jens Pedersen

 

[Dave Peterson]

You could change your regional settings under
Windows Start button|Settings|Control Panel|regional settings
Look for Number Tab (at the bottom) and change it.

Be aware that this is a windows setting and may affect other programs, too.

 

[Dave Peterson]

Are you saving the .csv from VBA?

If yes, then VBA is pretty much USA centric.

You may want to try Earl Kiosterud's Text Write program:

It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Or maybe write your own:
Chip Pearson has some nice get-started code at:
http://www.cpearson.com/excel/imptext.htm

If you're saving from excel (manually), are you sure you got the List separator
on the Number tab. I just tried it again and excel respected it for me.
(xl2002/win98)

(Not just the regional settings tab)

 

[Dave Peterson]

You can ignore VBA reference in my previous post. If you save from VBA, it
should have the commas. (That's actually difficult to change.)

Hey, wait. If all else fails, try recording a macro when you do it once. Then
run that macro when you want the commas.

(But I'm still betting on the list separator on the number tab <vbg>.)