The numbers automatically shown in exponential notation with E+n Find a cell in a table with very large numbersĬ. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Version 5.4.2 (506)ī. Which driver are you using and version of it (Ex: PostgreSQL 10.0): BigQuery Please do not ignore it or your issue will be closed. Please answer the questions below, it helps us to keep track of the issue. Can I request for an option/toggle to turn off auto conversion to exponential notation and just show the large numbers as is? This is because when I export the tables to CSV, the cells will have that "E+n" in them and it messes up my analysis without first converting it back to normal numbers. If I query the table directly on Google Cloud in the browser, the numbers are shown as is - no exponential notation. Hi, I'm connecting to BigQuery and noticed that large numbers are automatically converted to exponential notation (with the E+n at the end).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |