list separator settings

[culkebas]

I use windows 2000, excel 2000
I want to change list separator semicolon instead of comma

I try 2 method for change list separator settings.

1)Control Panel-Regional Settings-Numbers and I set ";" in the field list
separator


2)in the Key:HKEY_CURRENT_USER\Control Panel\International, I set ";"
value in the sList

I can't obtain any result

any idea?

 

[Don Guillett]

have a look in tools>options>international

 

[culkebas]

thank you for relationship but,

"tools>options>international" not exist in excel 2000