How to set the list separator

[Silva]

Hi all,
I'm in trouble with the list separator that Excel recognizes t
automatically separate in columns a csv format file.

The problem is the following:
on PC1, with Windows 2000 Professional OS, Excel recognizes "," as lis
separator, and actually presents my data as separated columns when
open the csv file.
on PC2, with Windows XP OS, Excel recognizes ";" as list separator, an
actually presents my data as separated columns when I open the cs
file.

Does it depends on a PC configuration? If I change the field "lis
separator" in "International Settings" on PC1, setting ";" instead o
"," , nothing changes.

Is there something to be setted on Excel itself?

Thank you in avance for your answers,
Regards
Silvan

 

[Frank Kabel]

Hi
normally changing this in the regional setting (in your Windows control
panel) should do. You may have to restart Windows

 

[Silva]

Thanks Frank, but what you suggestl is exactly what I did! Als
restarting the PC (2000 OS) nothing changes in Excel behaviour.
At the moment I don't know if the same happens on XP OS PC. I'll try a
soon as possible.
Silvan

 

[Jim Rech]

You didn't say what version of Excel you are using, but with Excel 2002 and
2003 there is a Tools, Options, International settings sheet that controls
this. I've never played with it to see if it works, so, fwiw.

--
Jim Rech
Excel MVP

| Thanks Frank, but what you suggestl is exactly what I did! Also
| restarting the PC (2000 OS) nothing changes in Excel behaviour.
| At the moment I don't know if the same happens on XP OS PC. I'll try as
| soon as possible.
| Silvana
|
|
| ---
| Message posted
|

 

[Silva]

Hi,
I checked about the possibility to set the list separator starting fro
Excel (2002) Tools-->Options-->International settings.
Unfortunately there I can configure only the number separato
parameters.

But in the meantime I saw some other strange stuff.
On XP PC (and Excel 2002) seems to be a big bug into the management o
the Control Panel -->International Parameters fields: in some cases i
doesn't save the new value written into the "list separator" field and
the next time you open "International Settings "window, it shows th
old value, in spite of the saving option it accepted.

Is there someone to help me to understand?
Thanks,
Silvan