>>Numeric values don't care how many decimal places you have. Your value would be correct just by using VAL() on the string, but be cautious, it may depend on set decimals to "see" it correctly.
>
>Yes, I was having issues with decimal values being lost or rounded up to 2 decimals. Seems that Gregory´s code is inmune to "SET" settings, except for the SET POINT TO "." caveat.
>
>Thank you for your comments,
>
>Carlos
Try something with the E, e.g.
myNumber = 1.2e12
What would you get with PADR and evaluate ?
If it's not broken, fix it until it is.
My Blog