 |
 | 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 / October 2007PROPER function
Hi all - Stupid me, maybe, but I can't get this function to work. The help file says: "PROPER (text) Text is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize." So the text I want to convert is in cell, say, I370. In helper cell J130 I enter =PROPER(I370) But all I get in cell J130 after hitting enter is =PROPER(I370). In other words, it doesn't seem to be acting as a formula --- it is just appearing literally. This is an inherited spreadsheet, so it's possible something is set screwy, but I have no idea what it is. Using Excel 2000. Thanks in advance for any thoughts. Craig Format J130 as General - it's currently formatted as Text, which means that XL's parser won't interpret it as a formula. > Hi all - > [quoted text clipped - 19 lines] > > Craig Sorry, that didn't change it. > Format J130 as General - it's currently formatted as Text, which means > that XL's parser won't interpret it as a formula. [quoted text clipped - 22 lines] >> >>Craig Hi Craig, Your cell is formatted as text. Format as General *and* re-enter the formula (F2, ENTER)  SignatureKind regards, Niek Otten Microsoft MVP - Excel | Hi all - | [quoted text clipped - 19 lines] | | Craig Ah, THAT did it. It was the re-entering the formula that I was missing before. Thanks a bunch, Nick! > Hi Craig, > > Your cell is formatted as text. Format as General *and* re-enter the formula (F2, ENTER) "cschiller1<at>earthlink.net" <"cschiller1<at>earthlink.net"> wrote: >Ah, THAT did it. It was the re-entering the formula that I was missing >before. Thanks a bunch, Nick! Tip for the future - you don't have to re-enter it. Just reformat, then press F2 and then Enter. >> Hi Craig, >> >> Your cell is formatted as text. Format as General *and* re-enter the formula (F2, ENTER) >> Signature__________________________________________________________________________________ Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all) What is on my Pocket PC? http://www.ehansberry.com/ Microsoft MVP - Mobile Devices www.pocketpc.com What is an MVP? - http://mvp.support.microsoft.com/ Or if there are multiple formulas, format as general then just select the column and do data>text to column and click finish or if there are multiple columns select them and replace = with = using edit>replace SignatureRegards, Peo Sjoblom > "cschiller1<at>earthlink.net" <"cschiller1<at>earthlink.net"> > wrote: [quoted text clipped - 4 lines] > Tip for the future - you don't have to re-enter it. Just > reformat, then press F2 and then Enter. That's what I did, as per Nick's suggestion below. Thanks. > "cschiller1<at>earthlink.net" <"cschiller1<at>earthlink.net"> > wrote: [quoted text clipped - 8 lines] >>> >>>Your cell is formatted as text. Format as General *and* re-enter the formula (F2, ENTER) Good chance that the cell with the formula showing was pre-formatted as text. Format to General and hit F2 then ENTER. If all formulas are showing then try hitting the toggle key for "show formulas" CTRL + ` backquote above Tab key Gord Dibben MS Excel MVP >Hi all - > [quoted text clipped - 19 lines] > >Craig Thanks to you too, Gord. All fixed. > Good chance that the cell with the formula showing was pre-formatted as text. > [quoted text clipped - 29 lines] >> >>Craig On Oct 17, 11:21 am, "cschiller1<at>earthlink.net" > Hi all - > [quoted text clipped - 19 lines] > > Craig Craig, Do NOT format the cell as "Text"; instead format as "General". After you've changed the formatting, select the cell with the formula and click on the formula in the formula bar and hit enter (to re-run the formula). This should fix your problem. Regards, Dustin Yep, all taken care of thanks to a previous suggestion. Thanks to you, too. > On Oct 17, 11:21 am, "cschiller1<at>earthlink.net" > [quoted text clipped - 32 lines] > > Dustin On Oct 17, 10:21 am, "cschiller1<at>earthlink.net" > Hi all - > [quoted text clipped - 19 lines] > > Craig Hi, so is it appearing literally in the cell? If yes, this is to be expected. Is it appearing literally in the formula bar? If yes, this is not to be expected. I am assuming that the formula bar shows the formula in the cell. Hope this helps. J~ Is J130 formatted as text? If so change it to general. Brian The cell (J130) is probably formatted as text - format it as General and then re-enter the formula (or double-click as if to edit and then press <enter>) Hope this helps. Pete On Oct 17, 4:21 pm, "cschiller1<at>earthlink.net" > Hi all - > [quoted text clipped - 19 lines] > > Craig
|
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.