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.
- btw, I did google it and at 25 digit number is indeed more that the number of grains of sand on all the beaches of the world, but far less than the total number of stars in the universe.
That is a lot of stars are they are each considerably larger than a grain of sand. It is sort of humbling to see how small we are in the grand scheme of things in the Universe. - Thank you so much! So, does that mean it is impossible to convert up to 25 digits?
- 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.
- Thank you, that's really helpful!
- Great info, lol, thanks again for helping!
