Convert Text field to Number field
Hi, please help! I try to convert the text field, 'plan_id' with 25 characters to the number field. . I tried using the following formula: ToNumber ([plan_id]) It gives me the wrong nu...
Forum Discussion
The floating point representation used by the computer only provides about 17 decimal digits of accuracy.
I do not think that there are any business commercial computer systems which can handle numbers of 25 digits. So if you need the 25 digits I suggest leaving it as a text field. It is highly unlikely that you plan to do mathematical calculations on the 25 digit number. I imagine that would represent about the number of grains of sand on all the beaches in the world or all the stars in the sky. It�s a very big number.