Change of field separator in csv files (comma separated)

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

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.



Jens Pedersen wrote:
>
> 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
ec35720@msn.com

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)

Jens Pedersen wrote:
>
> Thanks Dave, but I already tried to change this setting and it didn't change
> the delimiter in the CSV file...
>
> /Jens
>
> "Dave Peterson" <ec35720@msn.com> wrote in message
> news:3F02D5E2.225F2B17@msn.com...
> > 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.
> >
> >
> >
> > Jens Pedersen wrote:
> > >
> > > 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
> > ec35720@msn.com

--

Dave Peterson
ec35720@msn.com

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>.)



Jens Pedersen wrote:
>
> Thanks Dave, but I already tried to change this setting and it didn't change
> the delimiter in the CSV file...
>
> /Jens
>
> "Dave Peterson" <ec35720@msn.com> wrote in message
> news:3F02D5E2.225F2B17@msn.com...
> > 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.
> >
> >
> >
> > Jens Pedersen wrote:
> > >
> > > 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
> > ec35720@msn.com

--

Dave Peterson
ec35720@msn.com