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!

Export to excel - number gets rounded

458384May 23 2006 — edited May 23 2006

I am using the inbuilt export to CSV for a report.
In the report i have a field Emp-Id. Actually its a numeric field with width 16.

Now when i export it to CSV then a emp_id like 7241760330528889 opens in excel as
7.24176E+15. Now if you try to turn it into a number then it is rounded of and comes
as 7241760330528880.

The one way is to cancatenate a character with emp_id. But thats not a proper way.
Can anyone suggest how to overcome this problem.

Thanks in advance.
Ameya.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2006

Added on May 23 2006

#apex-discussions

4 comments

1,159 views