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

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.

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

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

On Feb 4, 2:12*pm, Khoshravan
wrote:
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.
--
R. Khoshravan
Please click "Yes" if it is helpful.

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

Can you just type the comma in the list separator box?

Khoshravan wrote:

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.

--

Dave Peterson

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

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


"Dave Peterson" wrote:

Can you just type the comma in the list separator box?

Khoshravan wrote:

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.

--

Dave Peterson