Remove Percentage Sign

C

Charles Deng

Hi All:

Is there anyone who would like to tell me how I can remove
percentage sign? Such as:

69.6% to 69.6

I successfully removed percentage signs before but I
forgot what I did.

Any help will will be very appreciated.

Charles
 
B

Bob Umlas

Just reformat the number as General. But 69.6% formatted as general is .696,
not 69.6, so you'd have to multiply by 100.

Bob Umlas
Excel MVP
 
G

Guest

Hi Bob:

Thanks a lot. But I have a huge file with some headings
and subheadings. I cannot do multiply by 100. I remember
I only copied and then used special paste to. And then I
changed some format. Finally the percentage signs have
gone.


Charles
 
F

Frank Kabel

Hi
try the following:
- put 100 in an empty cell and copy this cell
- select your other values
- goto 'Edit - Paste Special' and choose 'Multiply' to multiply them
all in one single step
 
Top