Posted 06 Mar 2014
Link to this post
I am attempting to use a formula to convert a string to a numeric field. I need to support very large numbers. When I use the CDbl function, it seems to only return 15 significant digits.
CDbl('345,234,231,234.45678') = 345,234,231,234.457
CDbl('791,345,234,231,234.45678') = 791,345,234,231,235
CDbl('791,345,234,231,487,234.45678') = 791,345,234,231,487,000
CDbl('0.45678834579852369425') = 0.456788345798524000000
Is there another function that I should be using that would convert these strings properly?