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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 decimal point
I don't have any experience in international settings, but it seems to me
that the issue comes from the fact that VBA settings are not automatically linked to Excel settings. You are using VBA to specify the value, and it is obviously interpreting 479,000 as 479.000 (Dutch settings) before it even gets written into the cell. I don't know if there is a way to set VBA itself to use international decimal settings; some other Excel person out there may need to answer that for you. -- - K Dales "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 decimal point
VBA works with US English setting, so use
ActiveCell.Value = 479.000 An alternative might be ActiveCell.FormulaLocal = 479,000 -- Regards, Tom Ogilvy "GP" wrote in message ... 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 |
Reply |
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) |