Formating numbers as percents

[cautiouschris]

Issue:
I've got a string of numbers that I need to change the format of in
excel (i.e. 3.52, -2.6, 0.22, 2.82 etc...) They are currently formated
as numbers and I need them in percents(%). When I select a cell and
change format to percent I get 352%, 26%, 22%, 282% etc. rather than
3.52%, -2.6%, 0.22%, 2.82%.
What is the trick to making this work?

Regards,
Cc

 

[jlclyde]

Issue:
I've got a string of numbers that I need to change the format of in
excel (i.e. 3.52, -2.6, 0.22, 2.82 etc...) They are currently formated
as numbers and I need them in percents(%). When I select a cell and
change format to percent I get 352%, 26%, 22%, 282% etc. rather than
3.52%, -2.6%, 0.22%, 2.82%.
What is the trick to making this work?

Regards,
Cc

If you are typing the numbers in then you have to type in .0352 to get
the percentage. If you remember from 3rd grade math that a percentage
is a proportion of 100% or 1. So if you had 50% it woudl be written
as .5. You take whatever number and divide by 100 or move the decimal
2 places to the left.

If excel is calculating the numbers for you then you are not
calculating it correctly. To get percents you need to divide the
smaller number by the larger number.

You can dived by 100 in the cell next to or below. In cell B1 =A1/100
if A1 had the number. You can then copy the formula to the rest of
the cels. If you no longer want to look at the 3.52 and only want to
see the .0352 (which can now be formatted to be a percentage) Then
copy the correctly formatted cells and paste special over the 3.52
numbers and choose numbers only.

 

[Dave Peterson]

put 100 in an empty cell
edit|Copy that cell
select your range to fix
edit|paste special|click divide
format those fixed cells
clean up that cell with 100 in it

 

[Bob Umlas]

enter 100 in an unused cell, copy it, select all your #s, use Edit/Paste
Special, click Values AND Divide. THEN format as %
Bob Umlas
Excel MVP

 

[cautiouschris]

enter 100 in an unused cell, copy it, select all your #s, use Edit/Paste
Special, click Values AND Divide. THEN format as %
Bob Umlas
Excel MVP







- Show quoted text -

Thank You! exactly the tip I needed. And no math lesson to go with it.