Scientific notaton when I paste into Excel spreadsheet

19 Views Asked by At

I am not sure of this is a problem related with Excel or SQuirrel SQL.

I have the following problem when I extract data from SQuirrel and "Paste" it into an excel spreadsheet.

My column, "SOME_FIELD" represent a list of random alpha numeric / numeric element that has "text" as format.

enter image description here

But when I scroll down and check for the others elements I see some with in scientific notation., like you can see below NUMBER+E+11

enter image description here

At the top there is the number without the "E+11"

The solution to this issue is to change the format of the entire columns to "text" before pasting the data from SQuirrel. I am curious why this occurs for some elements and not for the rest...

0

There are 0 best solutions below