MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Disabling Formulas, Not calculation

  Asked By: Willie    Date: Jan 17    Category: MS Office    Views: 1488

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

If there is an event which Fires when the arrow key is pressed, after a sign in
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]




No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Disabling Formulas, Not calculation Or get search suggestion and latest updates.