Number format changing in my User Defined Field when I save it

When you have a UDF with a data type of Number and a display type of Text, any numbers longer than 20 characters are converted to what looks like scientific notation. 
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. Log into eTapestry
  2. Create UDF called "Membership Number" which is a number field displayed as text
  3. Go to an account add the number 15487965315487632487 to this field (this is 20 characters long). Upon saving this converts to 1.5487965315487633E19.
  4. Then go to another account and add 1548796531548763248 to the membership number field. This displays correctly (this is 19 characters long) 
  5. Also when creating a report to pull out these numbers, they pull into Excel in the same notation. For example 15487965315487632487 displays as 1.5488E+19 and when you click into the cell it shows as 15487965315487600000 which is not the correct last 5 digits.  



Was this article helpful?