•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Permanently disable scientific notation
We have many long ID's in our database and scientific display of an export (to either csv or excel format) is simply an obstacle. How can it be permanently disabled? I did go to Options | Data and unchecked all the boxes - including the one regarding scientific notation. NO change in behavior. I still get the unwanted scientific notation bvehavior.
The run_id's are actually all different.
| job_id | run_id |
|---|---|
| 2.33396E+14 | 3.73E+14 |
| 2.33396E+14 | 3.73E+14 |
| 2.33396E+14 | 3.73E+14 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#scientific notation
#long ID's
#export
#csv
#excel format
#Options
#data
#behavior
#run_id
#job_id
#database
#unchecked