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.