I have a column of Model Numbers, with mixed data types. Grist auto assigns the column as Numeric Values.
- Non Numeric values have preceeding zeros
- Changing the data type to Text turns numeric values into scientific notation.
I have a column of Model Numbers, with mixed data types. Grist auto assigns the column as Numeric Values.
This is definitely a bug that needs fixing, thanks for letting us know. Here’s what you can do in the meantime:
IFERROR(str(int($Model)), str($Model))
That’s mainly to solve the scientific notation problem. For the preceding zeroes, that’s really weird, do you know what did which led to that? If you want to remove all preceding zeroes in the data, add .lstrip('0')
to the end of the formula in step 2. You can also use similar code in a column transform later on.