Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Antonio.

Asked: May 25, 2017 - 8:47 am UTC

Last updated: May 30, 2017 - 1:41 am UTC

Version: 10.5.10

Viewed 1000+ times

You Asked

Hi Tom,
When I export an Oracle Payables invoice to excel, the invoice number looks like 2016192010000759 but in MS-Excel it looks like 2016192010000750, and actually its a different number. how can I get along with this?

Kind regards

António

Details:
From the find Invoice window, I query some invoices from a supplier, the invoice number is about 16 digits long (for instance 20017779800001491), I export these invoice to excel spreedsheet but the invoice number looks like 2.00178E+16, when I use excel tools to format the number it goes like 20017779800001400, which has nothing to do with the one from the find invoice sreen.

Please advise

Regards

António


and Connor said...

This is an Excel issue. By default an automatic import (of a CSV file) will limit to 15 digits so you get rounding issue.

For example, if I create an Apex report based on the simple query:

select 20017779800001491 from dual

and then download the results from Apex, the resulting file *does* contain:

20017779800001491

However, when I double-click and auto-load that CSV into Excel, the precision is lost.

One workaround is to *not* auto-load, but use the Text Import wizard in Excel.

Is this answer out of date? If it is, please let us know via a Comment