There must be a setting somewhere in Excel that works that way.
There is a formula solution to this.. use below formula:-
Formula: copy to clipboard
=MID(B2,1,SEARCH(".",B2)+2)*1


see attached:- multiplying % and getting to original.xlsx

Regards,
DILIPandey
<click on below * if this helps>