Analytics Software

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!

How to export number fields in text format when exporting to excel

M. CoralloFeb 25 2009 — edited Feb 26 2009

Hello,
I have some fields in BI reports containing numeric codes starting with 00000... as, for example: "0000055123894".
When I export the report to Excel the BI formats these fieldes as numbers so I get in the excel sheet "55123894" instead of "0000055123894".
Is there a solution to this?

These fields have all VARCHAR2 as datatype so the bi recognizes them like text... but not while exporting.

Many thanks to anyone

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 25 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

1,330 views