Problem with converting scientific notation as text to numbers

Hello everyone,
I'm really struggling to convert this data I've extracted via a PDF to Excel conversion tool from texts to numeric values, especially those who are displayed in exponential notation. I'm not totally new to Excel, but I use it only occasionally and I never encountered such formatting.

Some displayed numbers have negative values as well negative exponents, but when I click on the cell, the minus signs are nowhere to be found in the formula bar. I attached a picture to show what exactly I mean by that.
I have to delete the E, the first and last number 2, write them again with the minus signs at the right places, then it will make the text convertible to a number.
Furthermore, I attached the Excel file with the hope of getting some concrete help.

Thanks in advance.

Originally Posted by MrShorty

This sort of thing often turns out to be an unexpected character somewhere in the text string. I debugged by:

1) =LEN(C6) to see if Excel is seeing more characters than I can see. In this case, the result is the expected length.
2) With that, I check the code number for each character in the text string =CODE(MID(J6,ROW(C1),1)) [copy down to see all characters]. What I quickly notice is that the hyphen characters used for "negative" are code 173 hyphen characters and not the the usual code 45 hyphen character. Excel only recognizes 45 hyphen characters to indicate negative numbers, so Excel cannot convert these text strings to numbers.

A quick Find/Replace command (Find what? ­[alt-0173] Replace with? -) quickly replaces the offending hyphen character with the appropriate hyphen character, and Excel automatically converts the text to number.

You identified the problem correctly, thank you very much! Had just to find and replace the hyphen characters to solve it.

Cheers