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

M

Macaco

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

Changing list separator still not working.

please help!!!

Thanks in advance.
 
J

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

Macaco

Sorry,

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

thanks
 
D

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
 
Top