Quick Formula Question

G

Guest

Dear Excel 2003 users,

I have a user in the field that likes to start formulas with a plus
sign (becasue she uses a numeric keypad without an equal sign).
Sometimes the formulas work, sometimes they do not. Here is an
example:

she enters +150/2

she could get:

=150/2 or 75

Why does Excel sometimes run an immediate result on the entry and
sometimes convert it to a proper formula (which is the desired
result)?

Thanks!

Kevin
 
D

Dave Peterson

Any chance she's hitting F9 after entering the formula (but before the enter
key)?

Or is there any chance she has a helpful macro that's jumping in where it
shouldn't?
 
D

Dave Peterson

Do you have a any userforms in that workbook?

Do you have any controls (like a textbox) that uses that cell as the
ControlSource?
 
Top