Skip to main content
Question

Convert Text field to Number field

  • May 1, 2018
  • 0 replies
  • 103 views
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?
    This topic has been closed for replies.

    • anomDiebolt
    • Registered
    • May 2, 2018
    The floating point representation used by the computer only provides about 17 decimal digits of accuracy.
    Terms & ConditionsAccessibility statement