 |
 | 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 / November 2006Excel 2003 deletes last parenthesis
I've just built a new computer and installed Excel 2003. I found an annoyance, which is different from the behavior in Excel 2002. 1. Enter some array formula into some cell. e.g. =ISNUMBER(A2:A5) 2. Note that it is displayed in the formula bar as {=ISNUMBER(A2:A5)} 3. Place cursor in the formula bar. 4. In addition to both braces disappearing, the closing (right) parenthesis also disappears. It will reappear under certain circumstances, but if you try to copy the formula, so as to paste it into another cell, or a NG message, the closing parenthesis will not be there. In Excel 2002, only the brackets would disappear when selecting the cell. I preferred the Excel 2002 behavior. Can this be changed back, or is there something odd about my setup? --ron It worked ok for me (no parens were harmed in the filming, er, nevermind). Are you sure it's not just mouse control??? > I've just built a new computer and installed Excel 2003. > [quoted text clipped - 16 lines] > > --ron  SignatureDave Peterson What you describe is NOT how Excel 2003 behaves on any of my computers; just the curly brackets disappear in edit mode. Have you tried other array formulas? best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > I've just built a new computer and installed Excel 2003. > [quoted text clipped - 18 lines] > > --ron Maybe your new mouse is far more "sensitive" than you are used to? SignatureKind regards, Niek Otten Microsoft MVP - Excel | I've just built a new computer and installed Excel 2003. | [quoted text clipped - 16 lines] | | --ron > Maybe your new mouse is far more "sensitive" than you are used to? Why do you think he hurt its feelings? <G> SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk " >I've just built a new computer and installed Excel 2003. > [quoted text clipped - 16 lines] > >--ron Thank you all. It is odd that I just tried it again, and the behavior is back to normal. Maybe my mouse was just "fooling around" with me. Or maybe there's something odd about my video driver. But knowing that the behavior was not "by design" does provide some comfort. Best, --ron Ron, Back to normal. Good. By the way, did you mean one of these? {=OR(ISNUMBER(A2:A5))} {=AND(ISNUMBER(A2:A5))} SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > On Mon, 06 Nov 2006 12:58:41 -0500, Ron Rosenfeld > <ronrosenfeld@nospam.org> [quoted text clipped - 35 lines] > Best, > --ron >Ron, > >Back to normal. Good. By the way, did you mean one of these? > >{=OR(ISNUMBER(A2:A5))} >{=AND(ISNUMBER(A2:A5))} No. Just =ISNUMBER(...) --ron
|
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.