Forum Discussion
Excel now simplifies written formulas. Information is lost
ecapo2330 wrote: ``I entered =(300/100)*(31/3)``
In my experience, the problem arises when you enter +(300/100)*(31/3) -- a leading plus ("+") instead of equal ("=") -- and the cell is formatted with a currency symbol (Currency, Accounting or a similiar Custom format).
Typically, this occurs when the formula is entered using the Numeric Keypad.
In fact, the simplest work-around is to enter with leading equal instead of plus.
Usually, that means using the normal keyboard, not the Numeric Keypad.
Alternatively, add superfluous parentheses around some numbers. For example: +(300/(100))*(31/(3))
Another work-around that I do not recommend is to set the Lotus Transition Formula Entry mode.
However, I do not recommend that because I do not know what all the side-effects might be -- unintended consequences.