View Single Post
  #1   Report Post  
GP
 
Posts: n/a
Default 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