Google spreadsheet backend treating a string starting with 0e as scientific notation

[ali-hussain]

One of the random string IDs I had created as a key for my data was 0e<valid digits>. When Appsheet API stored this in Google Spreadsheet it interpreted this as scientific notation and turned it into the number 0. Is there any fix around this?

[dbaum · Accepted solution]

In the spreadsheet, try setting the format of the column to Plain text.

[ali-hussain]

Thank you. I was looking for that option and couldn't find it. Would be nice if a type consistency option is added to Appsheet to enforce the type across the backend.