Convert Text field to Number field

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
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?
Photo of Katherine Phung

Katherine Phung

  • 248 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,462 Points 20k badge 2x thumb
The floating point representation used by the computer only provides about 17 decimal digits of accuracy.
Photo of Katherine Phung

Katherine Phung

  • 248 Points 100 badge 2x thumb
Thank you so much! So, does that mean it is impossible to convert up to 25 digits? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
Photo of Katherine Phung

Katherine Phung

  • 248 Points 100 badge 2x thumb
Thank you, that's really helpful!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
Photo of Katherine Phung

Katherine Phung

  • 248 Points 100 badge 2x thumb
Great info, lol, thanks again for helping!