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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.csv Commas ? 2
*.csv format change if .xlt save as .csv in Excel 2007 1
Save as CSV: extra spaces around commas 2
csv format is wrong in Denmark 3
Files saved as csv files are actually saved as text files? 4
Problem with CSV file 6
CSV Tab Delimited 4
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1

Back
Top