I'd like to try turning off the auto formula assumption in Excel.

I want to allow a user to enter either a Plus, Minus or Equals sign in a
cell and finish by
using an arrow key (to move to the next desired data entry cell). Nothing
else. It would
be nice not to require the text forcing single quote ['=] or a formula such as
[="="] .

You can do this if you use the [Enter] key, but then the cell selection
moves to where the
preference is set. However, when you use an arrow key, it is interpreted as a
formula and
the cell moved-to is inserted after the sign [Excel assumes you want a formula
referencing
that cell]. I could make the move-after-entry direction preference the most
likely, but
that can vary. I could also set the [enter]to not move the selection, forcing a
two key
finish-move operation.
Formatting the cell as Text converts a number to a string, but doesn't
convert these
signs into a string.

I could have the user enter text (a P, M or E), but the actual sign would be
nicer.

If there is an event which Fires when the arrow key is pressed, after a sign in
entered,
perhaps I could have a Macro add the leading single quote...but everyting I
found doesn't
fire when the arrow is typed, only after the [Enter]

Ideas?