The percent % is a formatting option. The real value of the cell is .10113



First of all make a copy of the Excel file in case something goes wrong.



To change the value, find an area the same size and put a formula in the
first cell of the new area. If the first cell of the block you want to fix
is B5, then enter =B5*100 in the first cell of the new area. Then copy this
formula to the other cells in the new area. Then select all the cells in the
new area and copy. In the first cell of the old area do a Paste Special
(chose Value).