Regional settings independent list separator in arrays
 

In some countries (like Slovakia, Czech Republic, ...) there is comma (",")
used for decimal symbol and semicolon (";") for list separator.

And that is my problem - in "standard US settings" you can:
- insert horizontal array into range of cells with comma (={1,2,3,4,5} and
press Ctrl+Shift+Enter)
- insert vertical array into range of cells with semicolon (={1;2;3;4;5} and
press Ctrl+Shift+Enter).

So - is there any way to work with those arrays in "regional settings
independent" way ?

Thans to all hints in advance !

Vlado

Regional settings independent list separator in arrays
 

Try toolsoptions and under the international tab, uncheck the "use
system settings" option and set "," as decimal separator and "." for
thousand separator. With these settings the list separators for arrays
become ";" and "\".

(XL2002/3)

Vlado Sveda wrote:

In some countries (like Slovakia, Czech Republic, ...) there is comma (",")
used for decimal symbol and semicolon (";") for list separator.

And that is my problem - in "standard US settings" you can:
- insert horizontal array into range of cells with comma (={1,2,3,4,5} and
press Ctrl+Shift+Enter)
- insert vertical array into range of cells with semicolon (={1;2;3;4;5} and
press Ctrl+Shift+Enter).

So - is there any way to work with those arrays in "regional settings
independent" way ?

Thans to all hints in advance !

Vlado

Regional settings independent list separator in arrays
 

Thanks a lot Lori !

It helped me. It is not necessary to uncheck the "use system settings"
option, I just replaced comma (",") with backslash ("\") and it works !

Once more time: Thank you !

Vlado

"Lori" wrote:

Try toolsoptions and under the international tab, uncheck the "use
system settings" option and set "," as decimal separator and "." for
thousand separator. With these settings the list separators for arrays
become ";" and "\".

(XL2002/3)

Vlado Sveda wrote:

In some countries (like Slovakia, Czech Republic, ...) there is comma (",")
used for decimal symbol and semicolon (";") for list separator.

And that is my problem - in "standard US settings" you can:
- insert horizontal array into range of cells with comma (={1,2,3,4,5} and
press Ctrl+Shift+Enter)
- insert vertical array into range of cells with semicolon (={1;2;3;4;5} and
press Ctrl+Shift+Enter).

So - is there any way to work with those arrays in "regional settings
independent" way ?

Thans to all hints in advance !

Vlado

Regional settings independent list separator in arrays
 

No problem, glad you got it to work.
ps The system setting override was suggested if you want to use theses
settings in the US version

Vlado Sveda wrote:

Thanks a lot Lori !

It helped me. It is not necessary to uncheck the "use system settings"
option, I just replaced comma (",") with backslash ("\") and it works !

Once more time: Thank you !

Vlado

"Lori" wrote:

Try toolsoptions and under the international tab, uncheck the "use
system settings" option and set "," as decimal separator and "." for
thousand separator. With these settings the list separators for arrays
become ";" and "\".

(XL2002/3)

Vlado Sveda wrote:

In some countries (like Slovakia, Czech Republic, ...) there is comma (",")
used for decimal symbol and semicolon (";") for list separator.

And that is my problem - in "standard US settings" you can:
- insert horizontal array into range of cells with comma (={1,2,3,4,5} and
press Ctrl+Shift+Enter)
- insert vertical array into range of cells with semicolon (={1;2;3;4;5} and
press Ctrl+Shift+Enter).

So - is there any way to work with those arrays in "regional settings
independent" way ?

Thans to all hints in advance !

Vlado