Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
Editing a list of data | Excel Discussion (Misc queries) | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |