CSV File, change separator sign

[MR MALTWHISKY]

I can not change separator sign creating CSV file in office2007 running on XP
PRO.
I want to have , as separator defalt is ;
I have changed in control panel nationals setting but it still does not give
me csv fil whit , as separator it keeps give me ; as separator.
Can anyone tell me how to solve this.

 

[JBeaucaire]

I've run into this myself, and eventually found it fastest just to use
NotePad or EditPad.

1. Export your .CSV doc
2. Open it in NotePad
3. CTRL-H to activate Search/Replace feature

Search: ;
Replace: ,

4. Save the .CSV file.