Decimal 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


0
kenbens (10)
7/11/2006 4:08:11 PM
excel 39879 articles. 2 followers. Follow

4 Replies
489 Views

Similar Articles

[PageSpeed] 9

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


0
kenbens (10)
7/11/2006 4:28:23 PM
Got that one too. Copy and Paste Special|Values.

Sometimes it helps to just write it down.

Ken Benson


0
kenbens (10)
7/11/2006 4:35:05 PM
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
>
> 


0
mbehm (14)
7/11/2006 4:54:43 PM
Ken Benson wrote:
> 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.

0
7/11/2006 5:05:43 PM
Reply:

Similar Artilces:

Number of days
I connection with some (simple) interest calculation (where interest rate is fixed every 1st July and 1st January and where interest calculation is based on 360/360) I need to know how many days at which interest rate. Let's say I have an amount which was due on 1st September 2008. Let's further say that in A1:A5 I have: A1: 1-Jul-2008 A2: 1-Jan-2009 A3: 1-Jul-2009 A4: 1-Jan-2010 A5: =Today() E2: First day of the interest period I have the following formula in B1: =IF(A1>=$E$2;DAYS360($E$2;A1;1);0) (I use semicolon as separator) Copied down to B5 this gives me: ...

Numbers changed to dates in cells
Hello, When I input something like 12-4 into a cell it converts it to December 4. How do I format the cells so they will leave my entries as is without converting them to dates or anything else? Thanks! Jeff Jeff, Format the cells as "Text" beforehand Format/Cells "Number" Tab, select "Text" or place an apostrophy before entering the number '12-4 John Jeff wrote: > Hello, > > When I input something like 12-4 into a cell it converts > it to December 4. > > How do I format the cells so they will leave my entries > as is without...

Checking Winning Numbers in the Lottery.
For people who may not understand the lottery rules for the UK. Person picks 6 numbers in the range 1 to 49 (no duplicates) If all the 6 numbers come up then when the lottery numbers are announced, then it is serious party time. Problem: - We have 25 people in our Lottery syndicate and therefore I want to automate the checking of numbers that are announced with numbers that are pre-selected by the 25 individuals. Additionally, I want to know how many numbers have matched in an individual row against those announced. E.G. Assume lottery number announced (in ascending sequence are) 1, ...

Restart Outline Numbering
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have created an outline that has multiple levels. In the outline numbering dialog box I have checked the box for &quot;restart numbering after&quot; for each of the levels 2, 3, and 4, and saved this in the template. <br><br>For level 2, the outline numbering does not start after level 1. However, for all subsequent levels, the outline numbering does start correctly. The box is correctly checked when I go in to review the settings for my outline numbering. I have tried to uncheck and sa...

use formula on external data range
Hi All, I've got a problem with data I read from a database. I wrote a VBA Sub in Excel 2007 with retrieves data via ActiveSheet.QueryTables.Add() per OLEDB out of a database. This works fine and puts the data in the range beginning on cell "A8" Now my problem: I have a formula '=SUM(A8:A10) in cell "B1". This formula always comes out = 0, although there are values in the cells. But if I edit cell "A8" without changing the value (just the alignment changes) it is recognized and the formula shows = 1 What am I missing here ? Thanks ...

Numbers will not copy between worksheets
I have an Excel workbook with two worksheets. One named Assests and the other named Print. Users enter data on the assets sheet and then run a macro that prints out the 'Print' sheet in a certain way. I have cells on the Print sheet linked to cells on the Assets sheet with a formula like this one: =IF(Assets!B10>"",(""&Assets!B10&""),"") This works great unless the value entered is just a number. If it's just a number with no letters, the value from the Assets sheet does not show in the corresponding cell on the Print sheet....

Get PCI Bus/Function/Device Number
Hi All, Is there a way to get the PCI bus, function and device number on which my current driver is installed. I could only find bus number in DEVICE_REGISTRY_PROPERTY. I had used WdfDeviceQueryProperty to retrieve this data. How can I get the function and device number? Thank You. Regards, Sushma Sushma <sushma.yella@gmail.com> wrote: > >Is there a way to get the PCI bus, function and device number on which >my current driver is installed. Why? That information is not very useful. >I could only find bus number in >DEVICE_REGISTRY_PROPERTY. I h...

IE toolbar question
Hi, anybody knows how to make toolbar after installation/registration to appear on IE automatically, without having to go to view/toolbars menu and checking it out ? I couldn't find any trace in IE registry settings. thanks Open a new browser instance than using the IWebBrowser2 interface from that instance, show your browser bar by calling ShowBrowserBar. After that the setting will stick. AliR. "andrew" <kc2ine@yahoo.com> wrote in message news:u4M1g8RRFHA.356@TK2MSFTNGP14.phx.gbl... > Hi, > anybody knows how to make toolbar after installation/registration to...

csv import into excel, preserving leading zeros in numbers
Hi, We have csv file automatically generated where rows look like: "0123","04567","089". The problem is that when Excel opens this file it puts it into cells like 123,456,89 stripping leading zeros. Is there way to generate csv file so that leading zeros won't be stripped so it would like 0123,0456,089 when the file is opened in excel. Thank you Vadim Hi Vadim, rename the file a .txt file. Then you will have a choice for the type of field, number or text -- Kind regards, Niek Otten "Vadim" <vadim@dontsend.com> wrote in message new...

max number
may anyone tell me how to find the largest number within a heap of numbers?? On Mon, 24 Nov 2003 00:44:43 +0800, "vivats" <vivats@netvigator.com> wrote: >may anyone tell me how to find the largest number within a heap of numbers?? > =MAX(Heap) --ron =max(rangeof heap) vivats wrote: >may anyone tell me how to find the largest number within a heap of numbers?? > > > > Assuming the "heap" is a range........ =MAX(A1:A10) Gord Dibben XL2002 On Mon, 24 Nov 2003 00:44:43 +0800, "vivats" <vivats@netvigator.com> wrote: &...

SOP NonInventory Unit Cost 6 Decimal Places
Is there any simple way to increase the currency decimal places to greater than the current highest value of 5? Thanx Scott, I don't believe there is any easy or even moderately difficult way to do this, as the field types used to store amounts in GP only go up to 5 decimal places. -- Victoria Yudin Dynamics GP MVP Flexible Solutions - home of GP Reports http://www.flex-solutions.com/gpreports.html blog: http://www.victoriayudin.com "Scott Rutledge" <sersoar@hotmail.com> wrote in message news:E102B81B-8555-400E-843C-240C58794294@microsoft.com... > Is there any...

Number Field in Table
Can I stop a record being saved if the number is 0 in a number field in my table? -- Thanks in advance for any help with this......Bob MS Access 2007 accdb Windows XP Home Edition Ver 5.1 Service Pack 3 I suppose >0 in validation rule would do it? "Bob Vance" <rjvance@ihug.co.nz> wrote in message news:ePHbBqiqKHA.4752@TK2MSFTNGP04.phx.gbl... > Can I stop a record being saved if the number is 0 in a number field in my > table? > > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home...

percentage breakout from list
Need to create a chart showing where time goes by time, and would like the percentage for each category along with piechart. just use the chart wizard. the pie chart option in has a "show percentage" setting ...

Help with SetWindowsHookEx (newbie)
Trying to trap messages from another process. I have already inserted a new menu item into the process, now I'm tryign to trap messages with with the following code: GetWindowThreadProcessId(HmbWindow, &threadID); HINSTANCE hModHnd = GetModuleHandle(NULL); g_hHook = (HHOOK)SetWindowsHookEx(WH_GETMESSAGE, (HOOKPROC)MyHookProc, hModHnd, threadID); g_hHook is always NULL. I'm not sure why, I have checked everything I can think of to check and it all looks fine. Here is what the MyHookProc looks like: LRESULT CALLBACK MyHookProc(int code, WPARAM wParam, LPARAM ...

Change a positive number to negative number
I have a column of positive numbers that I need to change to negativ numbers. Is there an easy way to do this? Right now I manualy make th change. Thank you, Pa -- patowen ----------------------------------------------------------------------- patowens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2456 View this thread: http://www.excelforum.com/showthread.php?threadid=38155 patowens, put -1 in an empty cell, copy that cell, select the numbers you want to change, right click and paste special, check multiply, OK. -- Paul B Always backup your data before tr...

How do you sort words in Excel by the number of letters in a word
I have a list of 5,000 words that I need sort by the number of letters in the word for my students is this possible to do? The words range from 1 letter to 9 letters in a word. with the use of a helper column =LEN(A1) if you do not want to count spaces =LEN(SUBSTITUTE(A1," ","")) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kinger" <Kinger@discussions.microso...

Need solution to formula problem
Help please! I have two rows of numbers with some cell that will contain 'N/A". If the top row is highest I need it highlighted yellow if it is not highest or is "N/A" the cell needs to remain with no fill. I can do a condtional formatting that works great until a cell contains the "N/A". Is there a formula that I can do in conditional formatting or some other options that will solve this problem. As suggested in your multi-post in .programming (please do not multi-post) Try this .. Select rows 1 & 2, and apply cond format Cond1's formula: =A$1=&q...

Internet header question
Does anyone know of any tool that could be ran against an outlook folder full of internet mail that would extract the SMTP address sent from for all of them and export it to any format? I'm going through spam from various users, and between the firewall and the antivirus software on my exchange server I want to add the IP's to a block list. But it's a pain opening them one at a time, getting to options, copying the IP, and pasting it into an excel spreadsheet. Thanks for any suggestions. John JDTHREE [MVP] <john@removeforspam.engagenet.com> wrote: > I'm going th...

How do you turn off the page numbering/header/footer command?
I turned on the page numbering command in Word 7 intending to number the last two of four pages as 1 and 2. When I could not get that to work and wanted to turn the command off and get back to the document, I could find no way, even using the on-line help feature of finding out how to do so. Please advise! Word 7 is Word for Windows 95. Presumably you are referring to Word 2007. You can't just turn off or restart page numbering for specific pages. You have to insert section breaks and proceed from there. See http://word.mvps.org/FAQs/Numbering/PageNumbering.htm. -- S...

Reduce currency decimals
Hi, Is there any tool which will reduce the currency decimals on our Great Plains system. We want to reduce our system currency decimals. Thank you. KT I'm not sure if this is what you mean, but there's Tools >> Utilities >> Inventory >> Change Decimal Places This utility can change the decimal places for items. I don't know of any system-wide change for decimal places. Eleni "KT" wrote: > Hi, > > Is there any tool which will reduce the currency decimals on our Great > Plains system. We want to reduce our system currency decimals....

decimal problem
Hi all I a very strange effect when using different decimal settings and calculating some values: DECLARE @Decimal1 decimal(5, 2) DECLARE @Decimal2 decimal(30, 2) SET @Decimal1 = 0.2 SET @Decimal2 = 0.2 SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal1)) SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal2)) The first result is correct (0.00000000025832000), the second is wrong, why ??? Thanks for any comments Best regards Frank Uray Hi Frank This is what happens when you multiple these precision&scales Precision 15 + 3...

Microsoft Money 2004 Standard Online services question
Hi, I am thinking about buying Microsoft Money 2004 standard. I bought quicken last year mainly because out bank supported transaction download only through quicken. A year after buying it the online service expired and I cannot even manually download and import transactions unless I renew the service. It is cheaper to buy a new copy of money standard then to renew the service in quicken. My needs are fairly simple so standard would do but I am wondering how long the basic transaction download services lasts in Microsoft Money. Our bank now supports both so I can go either way. I have not bee...

formula or VBA
I need to search through a column checking condtions. If the conditions are met, then I want to enter the corresponding value in the column next to it into a different cell. Basically, I want to search column A and, if the conditions are met, put the value in B into C. Would this be easier via formula or code? And maybe some starting suggestions would be nice if you don't mind. -- Thanks, Jim in a formula in col b =if(cond,a1,"") using vba for each c in range("a1:a100") if cond then c.offset(0,1)=c next -- Don Guillett SalesAid Software donaldb@281.com "...

** Few Questions
Hello all.. Few questions, and thank you for your help! 1 - How can I set up an email add. to forward to a AD users mailbox? For example, if joe@msn.com wanted to recieve all emails addressed to resumes@msn.com. *Without creating an AD user and forwarding the email*? 2 - Is there a way to create a contact list in Exch'03 for all staff to use? ex. When the user opens Outlook 2003, he/she will have the all staff contact list available. 3 - I know theres a 16GB limit when using Exch'03 Standard, but should I worry if no one is storing their mail on the server? If everyone store...

lining up numbers on calendar?
This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C91045.3F6FA900 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable As I was setting this up, I thought it sounds kind of picky (LOL) There are probably other templates that do more what I want, I just got = to using this one. (I usually use the "understated" one and adapt it to = what I want or think will work good) On this one (Varsity- Pub 2007) it seems like the numbers of the days = are too far to the left under the names of the days up top. It looks o...