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?

0 5 594
5 REPLIES 5

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

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.

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!

You’re welcome

Top Labels in this Space