Problems with Comma in Array Formulas

Hi, if the comma is the decimal separator try

{=(1;2;3;4;5;6)}

Hi, ediardp!

Thanks for the reply!

I tried, but this create a vertical array, instead of a horizontal one.

With {=(1,2,3;4,5,6)}, I'm trying to create something like this:

     A     B    C

1   1     2     3

2   4     5     6

While {=(1;2;3;4;5;6)} would create something like:

    A

1  1

2  2

3  3

4  4

5  5

6  6

Hi Gilberto,

Did you find the answer?

I'm starting with array formulas and I get the same problem. Following the try and error method I find the replace for "," in portuguese setting: for horizontal array try "\":

={1\2\3;4\5\6} SHIFT+CTRL+ENTER

Yes. That is correct.

If comma is decimal separator symbol, then \ is used in place of comma in Array.

If semi colon is decimal separator symbol, then \ is used in place of semi colon in Array. (Semi colon is row separator)