| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 imported csv file, truncation after decimal point | Excel Discussion (Misc queries) | |||
| Decimal Point Vertical Alignment in Excel 2003 | New Users to Excel | |||
| Decimal point will not hold 2 places in Excel 2003 | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| Decimal Point Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
