Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think this problem only occurs when you try to insert formulas with
an array. In Europe, f you examine a formula in a spreadsheet you'll see =if(x ; 0 ; 0), in US you'll see =if(x, 0 , 0). As far as I can tell, Excel isn't smart enough to translate the delimiters when they are stuffed into an array. Wiser people may have better explanations. Try this: control panel - regional settings - dutch(belgium) Then run your program. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regional Settings / Finding out Array separator characters | New Users to Excel | |||
Average of a difference between 2 cels in a table/array | Excel Worksheet Functions | |||
Second largest in array of difference in high-low values in cells | Excel Worksheet Functions | |||
Could someone tell me the difference in these formulas? | Excel Worksheet Functions | |||
Array difference? | Excel Programming |