how to change colon to semi-colon in CP/List Seprator

K

Khoshravan

In my excel (2003 with Win XP) the list separator is semi colon (;)
How ever in most of codes posted here the list separator is colon (,) For
copying codes from here, always I have to make a find/replace which is
tedious.
How can I change mine from ; to,?
I think it should be changed from control panel (cp) under "Numbers" tab,
List separator. But in my case only semi colon is available.
 
P

Pete_UK

I think it is to do with your Regional Settings, and so if you choose
a particular country then that's what you are stuck with. By the way,
the symbol , is a comma - a colon is :

Hope this helps.

Pete
 
K

Khoshravan

Thanks. IT solved the problem.
--
R. Khoshravan
Please click "Yes" if it is helpful.


Dave Peterson said:
Can you just type the comma in the list separator box?
Click to expand...
 

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

Formulas need semi-colon, how to change to comma 1
Save as CSV 2
change csv list separator in excel 2007 Dutch version 1
Data validation in Excel 2007 5
How do I generate an email list from my worksheet? 9
SQL statement needs to end with semi-colon? 4
CSV-file as semicolon se 2
How do I export Excel in a semi-colon delimited format? 4

Top