 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Decimal number to percentage formula (newbie question)
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 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. > 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 [quoted text clipped - 14 lines] > Thanks for putting up with a newbie > 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%. 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.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.