There is a formula solution to this.. use below formula:-There must be a setting somewhere in Excel that works that way.
Formula:![]()
=MID(B2,1,SEARCH(".",B2)+2)*1
see attached:- multiplying % and getting to original.xlsx
Regards,
DILIPandey
<click on below * if this helps>
Bookmarks