Link to home
Start Free TrialLog in
Avatar of lguifarro
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
Dim quantity as double
quantity = val(Qtytoinvoice.value) / rs("m")
'this gives me a number in scientific notation
msgbox quantity,vbokonly

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of lguifarro
lguifarro

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial