Decimal number to percentage formula (newbie question)

[Ken Benson]

I've got a column full of numbers like 0.5, 1.0, etc. I need them to look
like 0.500%. I figured out how to format the cells so that 0.5 looks like
0.500, but when I change the cell format to percentage, it makes 0.500 into
50.000%.

So I figured out how to make a formula that divides 0.500 by 100
(=R1C6/100), resulting in 0.005, which I can format to a percentage and get
0.500%.

Where I'm stumped is in applying that formula to the entire column. Instead
of =R1C6/100, I want my formula to say =all rowsC6/100. How do I tell it
{allrows}?

Thanks for putting up with a newbie
Ken Benson

 

[Ken Benson]

Okay, so I found the answer to my own question:

Select the entire column, type =RC6/100 and then press CTRL Enter. That very
nicely populated the entire column.

Now I want to get rid of column 6. IOW, I want to keep the results of my
formulas, but dump the formulas themselves.

Ken Benson

 

[Ken Benson]

Got that one too. Copy and Paste Special|Values.

Sometimes it helps to just write it down.

Ken Benson

 

[Michael Behm]

Ken,

You're on the right track. One way would be to insert a temporary column
next to your existing numbers column. In the temp column, use the formula
=R1C6/100. Copy that formula down to the bottom of your list. Excel will
automatically change the cell references for you. Now, copy the temp column
contents, then do a "paste special" into your existing numbers column.
Select "values" and all your numbers should be changed.

 

[Larry Bud]

I've got a column full of numbers like 0.5, 1.0, etc. I need them to look
like 0.500%. I figured out how to format the cells so that 0.5 looks like
0.500, but when I change the cell format to percentage, it makes 0.500 into
50.000%.

Just make a custom format for the cell of

0.000"%"

Putting the % in quotes treats it as a literal string and won't modify
the value of the cell to a percentage.