Probelms with csv

  • Thread starter Thread starter Luke
  • Start date Start date
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!!
 
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
 
Back
Top