Probelms with csv

L

Luke

Hi everyone,
i've a little problem.

When i open a *.csv file my excel (OfficeXP) use the comma (,) symbol as
column separator.

As the file are delimited by ; i use the "text to column" to use ;
instead of , to separate columns.

The real problem comes when i try to save the file! Excel save it with
the , as column separator, but i want it to save the file with ; column
separator.

How can i do?

Tnx!

Luca

P.S. Sorry but i've not found an answer to this question in this forum.
Peraphs there is, but i've not found it and i've a long work to end by
this evening and i've not so much time to search. Tnx very much to
everybody will help me!!
 
D

Dave Peterson

Try changing your windows regional settings list separator to a semicolon. But
this may affect other programs as well--you may want to toggle it back when
you're done.

In Win98:
Windows Start Button|Settings|control panel|regional settings applet
Number Tab|list separator
 
Top