View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vlado Sveda Vlado Sveda is offline
external usenet poster
 
Posts: 50
Default 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