Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal point
Hi
I have a code like this PrintSheet.Range("L24") = "=" & dasheet.Cells(2, 1) & "*" & adsheet.Cells(adix, 6) & "/" & adsheet.Cells(40, 6) and when the user put in like 500,35 in dasheet.Cells(2,1) it creates an runtime error. The problem dosn't occur when they ttype in 500.35. But im danish - and in denmark we use "," (comma) as decimal point. How can I change VB to use "," as decimail point instead of "." Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal point | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
decimal point | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Why am I getting .+ when I hit the decimal point? | Excel Discussion (Misc queries) |