MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Removing % sign

  Asked By: Kristopher    Date: Feb 13    Category: MS Office    Views: 1405

I have a question regarding excel.I have a spreadsheet in which i have values
with % sign.I want to remove those sign.For example 10.113% ..... like that
there are 200 entries in a row and I have around 20 such rows.I tried removing %
sign but it becomes 0.10113 but i want only 10.113.I can do it manullay one by
one but it will be very time consuming.Can anyone give me a quick tip on it.I
will really appreciate it.



4 Answers Found

Answer #1    Answered By: Dylan Evans     Answered On: Feb 13

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

Answer #2    Answered By: Kerry Wright     Answered On: Feb 13

I like that, far easier than what I suggested.

Answer #3    Answered By: Miriam Green     Answered On: Feb 13

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

Answer #4    Answered By: Alberta Miller     Answered On: Feb 13

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

Didn't find what you were looking for? Find more on Removing % sign Or get search suggestion and latest updates.