Decimal Point Excel 2003
 

Let say i have a macro like below n my regional setting = Dutch(Nerthelands),
the decimal symbol= "," and digit grouping symbol = ".". My excel i set it to
follow the system setting. When i run the macro below, the value return is
"497.000,00" instead of "479,00", is it a bug coz by microsoft 2003? Version
Excel 2002 is running ok

Sub Macro1()
Range("D4").Select
ActiveCell.Value = 479,000
End Sub

Decimal Point Excel 2003
 

VBA is pretty USA centric.

Try:
ActiveCell.Value = 479000
if you want 479 thousand.

try
ActiveCell.Value = 479
if you want 479


GP wrote:

Let say i have a macro like below n my regional setting = Dutch(Nerthelands),
the decimal symbol= "," and digit grouping symbol = ".". My excel i set it to
follow the system setting. When i run the macro below, the value return is
"497.000,00" instead of "479,00", is it a bug coz by microsoft 2003? Version
Excel 2002 is running ok

Sub Macro1()
Range("D4").Select
ActiveCell.Value = 479,000
End Sub

--

Dave Peterson