Weird...there seems to be an invisible digit between the dollar sign and the first number that screws things up. You can tell it's there, because if you put =MID(A2,2,1) into cell B2, it returns a blank. And if you put =CODE(B2) into cell C2, it returns 63, which is the character that is applicable to a question mark.
Don't know what that's about. But here's how to fix it...put this in cell B2 and copy down:
=VALUE(SUBSTITUTE(A2,MID(A2,2,1),""))
Bookmarks