When using Excel 2007 in a greek locale (greek menus) array constants'
separators for rows and columns work the other way around, i.e. ={1, 2, 3, 4}
means four rows in one column and ={1; 2; 3; 4} means four columns in one
row. It changed to the normal behaviour when I purchased and installed the
english environment.

Probably related to this is that N/A values in a greek locale are shown in
greek (Δ/Υ). This is a step too far, as I cannot share the workbook
internationally.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.crashesgpfs

What character separates the integer part from the fractional part of a
floating point number? When regional settings change that separator from a
period to a comma, the separator for function arguments changes from a comma
to a semicolon, which may be related to your observation.

Jerry

"vgee" wrote:

> When using Excel 2007 in a greek locale (greek menus) array constants'
> separators for rows and columns work the other way around, i.e. ={1, 2, 3, 4}
> means four rows in one column and ={1; 2; 3; 4} means four columns in one
> row. It changed to the normal behaviour when I purchased and installed the
> english environment.
>
> Probably related to this is that N/A values in a greek locale are shown in
> greek (Δ/Υ). This is a step too far, as I cannot share the workbook
> internationally.

No, this is not the cause. I have set an English locale for the same reason
(collaboration), so the saparator is the period (.). I think this should be
considered a bug, that means, an unwanted consequence of the Greek
localization.

"Jerry W. Lewis" wrote:

> What character separates the integer part from the fractional part of a
> floating point number? When regional settings change that separator from a
> period to a comma, the separator for function arguments changes from a comma
> to a semicolon, which may be related to your observation.
>
> Jerry
>
> "vgee" wrote:
>
> > When using Excel 2007 in a greek locale (greek menus) array constants'
> > separators for rows and columns work the other way around, i.e. ={1, 2, 3, 4}
> > means four rows in one column and ={1; 2; 3; 4} means four columns in one
> > row. It changed to the normal behaviour when I purchased and installed the
> > english environment.
> >
> > Probably related to this is that N/A values in a greek locale are shown in
> > greek (Δ/Υ). This is a step too far, as I cannot share the workbook
> > internationally.