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
|