ASP.NET, SQL Server, WPF, C#, VB.NET

Ken Benson wrote: 
 
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.

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. 
 
"Ken Benson" <kenbens@yahoonospam.com> wrote in message 
 
news:ua2a6QQpGHA.524@TK2MSFTNGP05.phx.gbl...

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

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

Got that one too. Copy and Paste Special|Values. 
 
Sometimes it helps to just write it down. 
 
Ken Benson