| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas need semi-colon, how to change to comma | Excel Discussion (Misc queries) | |||
| Save file as semi-colon delimited? | Excel Worksheet Functions | |||
| Semi Colon Deliminated File | Excel Discussion (Misc queries) | |||
| .CSV file format - comma or semi-colon? | Excel Worksheet Functions | |||
| .CSV file format - comma or semi-colon | Excel Worksheet Functions | |||
Linear Mode
