With your code and your cell content I get a runtime error from CDbl :
"Incompatible data types". This is normal because the string does not
represent a number. You should remove the apostrophe.
If you don't get a runtime error then you have somewhere an instruction
On Error Resume Next. Of course the result of CDbl is undefined in case
of error.
Bernard
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Try this code
Sub Main
Dim sVal as String
sVal = "0,30"
print CDbl(sVal)
End Sub
On my iBook with NeoOffice 1.1 I get 0,3
On a PC with Window XP professional and OOo 1.1.3 I get 0,3
On my PC with Debian and OOo 1.1.4 I get 0
Why???
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
