Search:     Advanced search
Browse by category:
Contact Us

Color Coding Conversion with Excel

Views: 1865
Votes: 0

Yes. As an example, in a conversion from PDF to Excel, the red letters in a PDF would be converted to red in Excel, green to green etc. The only exception is white, or almost white letters in PDF - they are converted to black; since white-on-white is not visible and people can be confused with such a conversion.
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?

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.

Others in this Category
document Font Problem
document Urgent tech support question



RSS