Discussions

Expand all | Collapse all

Convert Text field to Number field

  • 1.  Convert Text field to Number field

    Posted 05-01-2018 17:06
    Hi, please help! I try to convert the text field, 'plan_id' with 25 characters to the number field. 
    .">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1727836/RackMultipart20180501-73247-14w6gwt-Capture_1_inline.PNG?1525194105">. 
    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?


  • 2.  RE: Convert Text field to Number field

    Posted 05-01-2018 20:11
    The floating point representation used by the computer only provides about 17 decimal digits of accuracy.


  • 3.  RE: Convert Text field to Number field

    Posted 05-01-2018 20:41
    Thank you so much! So, does that mean it is impossible to convert up to 25 digits? 


  • 4.  RE: Convert Text field to Number field

    Posted 05-01-2018 22:18
    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.


  • 5.  RE: Convert Text field to Number field

    Posted 05-02-2018 15:10
    Thank you, that's really helpful!


  • 6.  RE: Convert Text field to Number field

    Posted 05-02-2018 15:14
    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.


  • 7.  RE: Convert Text field to Number field

    Posted 05-02-2018 23:38
    Great info, lol, thanks again for helping!