G
GP
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
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