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 the default Excel behaviour. Numbers that are very long (such as 447787574382) are represented in exponential notation.

The solution is therefore to do the conversion. After that, open the resulting Excel file and select ALL the numbers from the number column, then right click on them and choose "Format Cells" option. Then instead of the "General" choose the "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