lguifarro
asked on
How to Converto from Scientific Notation to a Two decimal float in VBA for RW
Hello:
i'm using VBA in RW and when i divide two strings using the val function, i get the result in scientific notation and i want them in a two decimal float, how do it.
I think thare are two ways, in the RW using the format option of the calculated field or in VBA, both are fine with me, but i don't know how to do it either way.
I attached the code i've used in VBA.
Regards
Luis
i'm using VBA in RW and when i divide two strings using the val function, i get the result in scientific notation and i want them in a two decimal float, how do it.
I think thare are two ways, in the RW using the format option of the calculated field or in VBA, both are fine with me, but i don't know how to do it either way.
I attached the code i've used in VBA.
Regards
Luis
Dim quantity as double
quantity = val(Qtytoinvoice.value) / rs("m")
'this gives me a number in scientific notation
msgbox quantity,vbokonly
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.