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.
Dim quantity as double
quantity = val(Qtytoinvoice.value) / rs("m")
'this gives me a number in scientific notation