Can someone help me understand why when I use normal editing gestures in any of the input boxes within the Data Validation popup, that it behaves so badly.  For example, I have the following formula: =AND(LEN(A1)=8, ISNUMBER(VALUE(MID(A1,1,7))), RIGHT(A1,1)=”B”).  I go to the Formula box and change the B to a Q.  The B remains there despite typing over it.  However, when I close it and re-open, the Q is there.  Or if I try to use an arrow key to move within the text, it starts adding cell references.  

I just don’t understand why it behaves so differently from any other input box.  

​Can someone help me understand why when I use normal editing gestures in any of the input boxes within the Data Validation popup, that it behaves so badly.  For example, I have the following formula: =AND(LEN(A1)=8, ISNUMBER(VALUE(MID(A1,1,7))), RIGHT(A1,1)=”B”).  I go to the Formula box and change the B to a Q.  The B remains there despite typing over it.  However, when I close it and re-open, the Q is there.  Or if I try to use an arrow key to move within the text, it starts adding cell references.   I just don’t understand why it behaves so differently from any other input box.    Read More

​