BUG: Eliminate partial-formula evaluation "feature" for formulas of the form +...
If A1 is formatted as Currency (et al) and we enter the formula +11000/12 (note: +..., not =...), the formula is replaced with the constant 916.666666666667. This can lead to a number of problems.
If course, we lose the formula. So we can no longer edit it.
If A2 is =MATCH(11000/12,A1,0), it initially returns 1 (match). But if select A1, press f2, then Enter, A2 returns #N/A (no match) because the exact binary representation of 11000/12 is replaced with the binary representation of the constant, which are not the same.
If we enter +6/4/2/4 into A1, it is replaced with the formula =1.5/0.5, which displays $3.00. That is incorrect. Note that =6/4/2/4 correctly displays correctly display $0.19 (exactly 0.1875). FYI, 6/4/2/4 is equivalent to 6/(424) algebraically.
If A1 is formatted as Accounting (e.g.) and we enter +11000/12, not only is the formula replaced with the constant evaluation, but also the format is changed to Fraction(!).
The partial-formula evaluation "feature" occurs only for certain formats. Currency and Accounting are two examples. But other users have demonstrated the problem with certain Custom formats. All seem to include the currency symbol.
Oddly, we can avoid partial-formula evaluation by setting the Advanced Lotus Compatibility option "Transition formula entry". But that option might have unintended side-effects.
The problem can also be avoided by entering formulas using =... instead of +... . But some users insist on using +... because it can be entered using only the numeric keypad.