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
change csv list separator in excel 2007 Dutch version 1
Semi-colon vs Comma in Functions 2
How to sort semi colon seperated items in alphabetic order? 1
How to make table of contents for different regional settings? 3
.NET 3.5 - how to change default number separator 1
Need RegEx To Find Corrupted Hyperlink 3
Exporting to CSV File - getting semi-colon instead of comma as delimiter. 8

Top