View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GP GP is offline
external usenet poster
 
Posts: 11
Default Excel 2003 decimal point

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