A single quote keeps getting added when a 0 precedes an integer regardless of the entry method for the cell’s value (e.g., when the values are imported into Smartsheet from an Excel file, when the values are copied and pasted into Smartsheet or when the values are manually entered).
Example: 099999999 changes to ‘99999999
Why does this happen and how do we prevent this from happening? When this happens, it also messes up A to Z sorting.
There are also some instances where imported integers without leading zeroes have a single quote added by Smartsheet.