Exporting CSV data and using semi colon instead of comma

[Michel Girard]

Does anybody know of a way to export data in excel as a
CSV file and use a semi colon( as the separator instead
of a comma (,)?

I can do it through a macro, but don't want to use that
if I don't have to.

Thanks
Michel

 

[Dave Peterson]

Try changing your Windows Regional settings.

Windows Start Button|settings|Control Panel|Regional Settings Applet
Number Tab|List separator

Don't forget to change it back when you're done. It's a windows wide setting.

And if you do decide to go the macro route:

Earl Kiosterud wrote a text export program. It's available at:
It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Earl has a bunch of options that you can specify.

And you may want to look at Chip Pearson's code:
http://www.cpearson.com/excel/imptext.htm