This will be a two step operation for each affected range of cells

1)First U will need to change the format of the all affected cells
to General (or some other format eg ,)
Format -> cells -> General (in the Number Tab)
(This will cause the number to change from 10.0113% to 0.10113 in
your example)

2) Then U will need to multiply all the cells by 100
In an empty unused cell type 100
Copy that cell

Select the range of cells that U want to change (in your eg: from
0.10113 to 10.0113)

Select Edit-> Paste Special
In the Dialog box select (Paste) Values and (Operation) Multiply

And Select OK

I like that, far easier than what I suggested.

Define the percentage as a number with three decimal places rather
than as a percentage. Multiply the value by 100.

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).