When exporting to Excel Instance, the exported numerics have extra decimals added to the number. The actual value in the database and shown in the Toad data grid does not use these decimals/zeros.
The number format setting for Toad''s Grid is "Standard" (Options | General | Grid). The table's column is of type numeric(18,0).
The data displays in the grid as whole numbers (i.e. 1, 20, 7891). Run a query and retrieve the data in the data grid. The values look correct here. Right click | Export | Excel Instance (or export wizard and then chooses Excel Instance in there). This exports into Excel with extras zeros (i.e. 1.00000, 20.00000, 7891.00000).
Why are there extra decimal/zeros and how do you export without these?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center