I'm doing some string manipulation on a Calculated Field which involves lookup, substring, replace functions with the return value of string. However, whenever the string is of a certain pattern [0-9]+E99 for example:
it gets converted to this notation:
This also happens in Excel btw, but normally, you just prefix string values with ' (single quote) to resolve this in Excel
In Nintex Forms, I'm not having this luck. The 'dirty' solution I have is to attach an extra non-numeric character (ex 54E99 becomes 54E99A), then I do a substring to remove the last character whenever I do some string comparisons. It works, but the problem again happens when I try to save the value to a column. Either I save the value as e+100 notation and run a workflow to remove it, or save the extra character 'A' and truncate it via workflow. This becomes a problem if the list using this column becomes a reference list in other parts of the site.
I'm I missing any tricks here? Please share you thoughts. Thanks.