changing the semicolon as separator in csv

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

console1 - 03 Sep 2007 21:28 GMT

hi all

when i save a worksheet to a .CSV Excel uses the semicolon ";" character
as the default separator

Where do I chnage the setting so that it uses a comma "," character?

thanks

Reply to this Message

Dave Peterson - 03 Sep 2007 22:29 GMT

In Windows XP, it's under the control panel|Regional options tab
then click customize and look for List separator on the Numbers tab.

Or you could rename your .csv file to .txt

And the specify the delimiter when you get the text import wizard.

> hi all
>
[quoted text clipped - 4 lines]
>
> thanks

Signature

Dave Peterson

Reply to this Message

Earl Kiosterud - 04 Sep 2007 01:21 GMT

If you're in the US, or another country that uses the comma normally for a separator, then
changing the Windows Regional setting will be good. If you're in a country that normally
uses the semicolon, then you might want to leave your regional settings to match your
country. In that case, try using the Text Write Program at
http://www.smokeylake.com/excel/text_write_program.htm.

It writes a text file from a worksheet, leting you specify things like the field separator,
independent of Windows settings.

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> hi all
>
[quoted text clipped - 4 lines]
>
> thanks

Reply to this Message

Rate this thread: