Toad
If exporting a data grid with Numbers or Integers to an Excel file, TOAD will always include the thousand separator, even if the "Use only 'General' cell formatting" option is checked.
STEPS TO REPRODUCE:
- Create this table and data:
CREATE TABLE EXCEL_TEST
(
INTEGER_COLUMN INTEGER
);
/
insert into EXCEL_TEST (INTEGER_COLUMN) Values (99999);
/
- Open up Schema Browser, Tables tab, Data Tab for this table
- Right click in the Data Grid, Save As
- Select "Format = XLS File" and Options: "Use only "General" cell formatting"
- Choose a file and hit OK
- Open up the file in Excel
- Notice that the numbers are shown as:
99,999
whereas if they are in "General" format, they get shown as:
99999
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center