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