R
Roger Wildensten
I am exporting data from an Oracle database to a file that
we want to view in Excel. This file will contain cells of
binary information. This will mean that selected cell
will have leading zeros. If we enter this data directly
in excel, use of apostrophe "'" will maintain the leading
zeros. However, because the source of the file is Oracle
on a Unix server, is there special formatting that can be
applied when the file is created to maintain the leading
zeros, and maintain the ".xls" file extension?
Reference: Microsoft Knowledge Base Article - 214233
we want to view in Excel. This file will contain cells of
binary information. This will mean that selected cell
will have leading zeros. If we enter this data directly
in excel, use of apostrophe "'" will maintain the leading
zeros. However, because the source of the file is Oracle
on a Unix server, is there special formatting that can be
applied when the file is created to maintain the leading
zeros, and maintain the ".xls" file extension?
Reference: Microsoft Knowledge Base Article - 214233