APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

leading zeros are dropped when exporting as csv

12247Jun 26 2007 — edited Jun 2 2008

I have a report that when I export as csv, leading zeros in text columns are dropped in excel. The text columns appear fine in the report, however, when I export the leading zero is gone in excel. For example, in the report my text column could have a value of 0101, when it is exported to excel it has a value of 101. The code behind the link to export to csv is f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:FLOW_EXCEL_OUTPUT_R#REGION_ID#
Is there a way to keep the leading zero in excel?
Regards
Mark

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2008

Added on Jun 26 2007

#apex-discussions

5 comments

6,818 views