Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Kristopher Davis   on Feb 13 In MS Office Category.

  
Question Answered By: Dylan Evans   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

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

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


Tagged: