ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   list separator settings (https://www.excelbanter.com/excel-discussion-misc-queries/61399-list-separator-settings.html)

culkebas

list separator settings
 
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

list separator settings
 
have a look in toolsoptionsinternational

--
Don Guillett
SalesAid Software

"culkebas" wrote in message
...
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?




culkebas

list separator settings
 
thank you for relationship but,

"toolsoptionsinternational" not exist in excel 2000

"Don Guillett" wrote:

have a look in toolsoptionsinternational

--
Don Guillett
SalesAid Software

"culkebas" wrote in message
...
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?






All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com