Excel 2003 deletes last parenthesis

R

Ron Rosenfeld

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
 
D

Dave Peterson

It worked ok for me (no parens were harmed in the filming, er, nevermind).

Are you sure it's not just mouse control???
 
B

Bernard Liengme

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
 
N

Niek Otten

Maybe your new mouse is far more "sensitive" than you are used to?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
E

Earl Kiosterud

Ron,

Back to normal. Good. By the way, did you mean one of these?

{=OR(ISNUMBER(A2:A5))}
{=AND(ISNUMBER(A2:A5))}
 
Top