Toad World® Forums

Toad for Oracle 14.1.120.943 NOT displaying numbers in datagrid

Toad For Oracle 14.1.120.943

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.

Thanks,

Brad