BUG !!! Excel 2002 save as csv coma not works in windows xp

[Macaco]

BUG !!! Excel 2002 save as csv coma not works in windows
xp.

Changing list separator still not working.

please help!!!

Thanks in advance.

 

[JE McGimpsey]

It's difficult to help if you don't say what's not working...

What format do you expect, and what does XL produce? Give an example of
your data in your post.

 

[Macaco]

Sorry,

when expecting comas as a list separator, appears
everytime semicolon.

thanks

 

[David McRitchie]

It may be called a comma separated values
but whether commas are use or semi-colons are used depends
on your Regional Settings in your control panel.

I you want to make your own choice without changing your
regional settings you can use a subroutine on Chip Pearson's
site. Look in his topic.htm for
Exporting to Text Files
http://www.cpearson.com/excel/imptext.htm#Export