Formula not being stored any more

[Steve Dinning]

Recently, Excel has stopped storing certain formulae in
the formula bar. For example, if I type in say "=3*1/10"
Excel will store "=0.3" in the formula bar. This is most
inconvenient as I want to be able to tell what the
constituent parts of the calculation are. It never used
to do this so have I accidentally set an option on
somewhere? How do I turn it off again?

 

[Dave Peterson]

I couldn't duplicate this.

If I typed:
=3*1/10
and hit F9 (calculate)--not enter
I got:
0.3

You're not getting close to the F9 key (with only portions of your formula
selected? (Yeah, I didn't think so!)