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 | |
29 | |
25 | |
23 | |
13 |