numbers appearing in raw data won't convert to an Excel value

I've attached a worksheet illustrating a problem I'm having getting Excel to recognize a column of "numbers" as they appeared in an original .pdf document which I exported to Excel.

I've tried TRIM, CLEAN, NUMBERVALUE, and have also tried removing commas and $ signs, but nothing works. I've also tried substituting the 0 for another 0 in the event the "number" in column G is the letter "O." But none of these work either.

Interestingly, if I manually change one of the zeroes in column G to a "1", then Excel recognizes the entire number as a value. I can manually change other digits in column G, so I really don't think it is an image.

Any thoughts?

Thanks Much.

You had extra spaces at the end of the 1040 in G1. Click on G1 and in Formula bar go to the end and get rid of the extra spaces at the end.

For G2 do you really want -540? Take the - out and it works.

You've got quite a bit going on there, this works for those examples.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G1,"$",""),CHAR(160),""),UNICHAR(8208),"-")+0

Thanks Fluff and Bo! As always, I appreciate your help.

Glad to help & thanks for the feedback.