Entering text that ends in E4 or E3 recognized as scientific notation


I have some data (text) that ends in “E3” or “E5”. When it gets saved to google sheets, it gets converted to scientific notation.

Example: 0319191425E4 --> 3.19E12

Do I need to turn off automatic formatting every time I create a column in Google Sheets to handle this data, or is there a better way?

(Aleksi Alkio) #2

Change the column type to “Plain text” in your gSheet and it should do that job.

1 Like

Yes, that is what I meant when I said “turning off automatic formatting.” Is there a better way to do this that will happen application wide? I have lots of columns that may contain this data.

(Aleksi Alkio) #4

The basic idea is that you set all column types correctly on the sheet side before converting anything into your app.


This makes sense. Thank you!

(Aleksi Alkio) #6

You’re welcome