Convert Text field to Number field

Question

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?

quickbasecoachd · Answer

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.

_anomdiebolt_ · Answer

The floating point representation used by the computer only provides about 17 decimal digits of accuracy.

katherinephung · Answer

Thank you so much! So, does that mean it is impossible to convert up to 25 digits?&nbsp;

quickbasecoachd · Answer

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.

katherinephung · Answer

Thank you, that's really helpful!

Forum Discussion

Convert Text field to Number field

Related Content

Add hyphens to phone number field

Roundup whole number

Converting delimited text into checkboxes

converting text to number

Converting Number to Text