Convert Text field to Number field

• 0
• Question
• Updated 1 year ago
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 number with eight '0' at the end instead of the above number. Do you know why?
• 248 Points

Posted 1 year ago

• 0

Ⲇanom the ultimate (Dan Diebolt), Champion

• 30,204 Points
The floating point representation used by the computer only provides about 17 decimal digits of accuracy.
• 248 Points
Thank you so much! So, does that mean it is impossible to convert up to 25 digits?
• 70,014 Points
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.
• 248 Points
Thank you, that's really helpful!
• 70,014 Points
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.
• 248 Points
Great info, lol, thanks again for helping!