Toad For Oracle 220.127.116.113
Larger numbers are being displayed in scientific notation in datagrids.
This is the case even after when "use scientific notation" is UNCHECKED
This persists upon export to excel rendering the column useless for both viewing and exporting
If you are running your SELECT with F5 (Run as script), run with F9 (Execute statement) instead.
I went in and looked this morning and the problem seems to have corrected itself?
It is displaying 15 digit numbers as numbers. Don't know why, just glad this is the case.
It works f5 and f9
Thank you for your help just the same. I have a related question regarding your answer but will post that as a new topic as it is unrelated.