Here is another formula that you can use to generate the
corrected values in order to Copy/PasteSpecial/Value them
over top of the existing values)...

=SUBSTITUTE(A1,".","")/100

Then copy/

I have no idea what happened to my posting... misplaced text, no signature
line??? Anyway, the idea should be obvious given the previous postings...
ultimately, I just wanted to offer that simpler formula for your
consideration, that is all.

Rick Rothstein (MVP - Excel)