comma's in a formula (esp an array)

F

Frank Kabel

Hi
you may either have a look at your regional settings or in
the VBA editor in the immediate window enter

?Application.International(xlColumnSeparator)
-----Original Message-----
Probably due to language / country settings I have some
Click to expand...
difficulties entering my array formula. Excel help states
that the formula =INDEX({1,2;3,4},0,2) should work, but
when I try to, Excel sees 1,2 as one number... What is the
seperator to enter an items within a row of an array if
the comma is part of the number? (I tried . / | but they
didn't work...
 
Top