DESFORMAT=spreadsheet and formatting issues in excel
660131Jan 28 2009 — edited Apr 1 2009Hi all,
Using reports builder 10 I have created a report layout for use with spreadsheets but am having trouble with a couple columns. In the data model the columns are just a straight select, they are varchar2 in the table.
The columns themselves contain entries like 00000001234 where the values differ, but are always padded with zeros to be 11 chars long. This is not a numeric column although it only contains numbers. in the properties of the report they are shown as varchar2 but when I run the report or generate it to .xls and open it, the column always appears without the padded zeros like excel thinks it is a number.
Is there a way to get around this?
Edited by: a small rabbit on Feb 24, 2009 9:54 AM