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?
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
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |