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.

- Non Numeric values have preceeding zeros
- Changing the data type to Text turns numeric values into scientific notation.

1 Like

This is definitely a bug that needs fixing, thanks for letting us know. Hereâ€™s what you can do in the meantime:

- Create a
**new**column. Unfortunately â€śApply formula to dataâ€ť doesnâ€™t seem to work in this case. - Enter this formula in the new column:
`IFERROR(str(int($Model)), str($Model))`

- Under Column settings, set the type to Text, then next to â€śFORMULA COLUMNâ€ť, click ACTIONS > Convert to data column.
- Now you can delete the original column and rename the new one.

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.

1 Like