G
Gertjan Huiskes
I have the following problem:
I set Windows to Dutch (dot as thousand seperator and comma as decimal
sererator)
The format of cell A1 and A2 is both General
In cell A1 I have this formula: =1234/1000
Excel displays 1,234 (comma)
From VBA I execute the following statement: Range("A2").Value =
CStr(Range("A1").value)
I should expect that 1,234 (comma) is displayed in cell A2, as a value, or
at least as a string
But cell A2 displays 1.234 (dot) and contains the value 1234
The format of cell A2 has been changed by Excel to 'Number' with 0 decimals
and using thousand seperator
It seems Excel is calculating somewhere using a comma as thousand seperator.
Is there some setting in Excel to change this?
I'm working on Windows XP Pro
I tested it with Excel 2000 (NL); Excel 2003 (NL) en Excel 2007 (Eng)
Gertjan
I set Windows to Dutch (dot as thousand seperator and comma as decimal
sererator)
The format of cell A1 and A2 is both General
In cell A1 I have this formula: =1234/1000
Excel displays 1,234 (comma)
From VBA I execute the following statement: Range("A2").Value =
CStr(Range("A1").value)
I should expect that 1,234 (comma) is displayed in cell A2, as a value, or
at least as a string
But cell A2 displays 1.234 (dot) and contains the value 1234
The format of cell A2 has been changed by Excel to 'Number' with 0 decimals
and using thousand seperator
It seems Excel is calculating somewhere using a comma as thousand seperator.
Is there some setting in Excel to change this?
I'm working on Windows XP Pro
I tested it with Excel 2000 (NL); Excel 2003 (NL) en Excel 2007 (Eng)
Gertjan