Call Support: +1 (647) 557 5884

I have a PDF file with very long numbers in it. For example, the number as it appears in one column is: 447787574382. However, when converted to Excel, the number that appears in the Excel cell is: .47788+11. What is the problem here?

Follow

This is simply default Excel behaviour.  Numbers that are very long (such as 447787574382) are represented in exponential notation.

The solution to this is to: do the conversion, then select ALL the numbers from number column and then right click on them and choose “Format Cells” option. Then instead of “General” choose “Number” and set number of decimal places to 0.

This article refers to Able2Extract  and Able2Extract Professional.

Have more questions? Submit a request

Comments

Powered by Zendesk