Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know how "Managed NewsGroup Support" works? I
am a MSDN Universal subscriber and refering to info from Microsoft I am guaranteed response wihtin 2 business days... How do they know I am guaranteed that when I post a question? However here is the question again that I don't got any answer on, maybe someone can help me now... Thanks in advance. I use intersect to get values from an array to a sheet. Everything works fine in Excel 97,2000 and XP. But in Excel 2003 it fails when a number contains a comma as decimal delimiter. Excel 2003 seems to always use period as a decimal delimiter even if my national settings says comma. Example: Dim Arr As Variant ReDim Arr(0, 0) Arr(0, 0) = "123,345" Intersect(Range("A1"), Range("A1")) = Arr This will return "123 345" in Excel 2003 and 123,345 in all other versions. Is this a bug? BTW, i've checked "Use system separators" in the options dialog. Any tip will be appreciated /Nicke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link to Help topic? | Excel Discussion (Misc queries) | |||
How is a a help topic example selected? | Excel Discussion (Misc queries) | |||
Topic did not show up? | Excel Worksheet Functions | |||
example in the help topic | New Users to Excel | |||
Off Topic Messages | Excel Worksheet Functions |