Appreciate the feedback Mark. That is the most useful feedback I have received thus far. Although no solution (yet?) you have distilled the problem's root cause one step further. Thanks.
In G10, replace =EXP(1)^G9 with =(EXP(1)^G9).
In other words, add "redundant" parentheses. Works for me.
(But =EXP(1)^G9+0, adding a "redundant" +0, does not work. That surprises me, given that redundant parentheses work.)
OK, I'm getting the same behavior now but only with that type of formula. From my limited tests it appears it is the use of the ^ that is causing it
I agree, so far. But the behavior is indeed similar to what I encountered 2 years ago, and there was no exponentiation in my formula then.
In any case, this has nothing to do with Manual or Iterative calculation modes. I can duplicate the misbehavior in Automatic calculation mode.
And this has nothing to do with PI, COS, LN or EXP. I replaced all of those with simple arithmetic operations. My G10 is of the form =2^G9. I alternate between 2 and 3 to force recalculation.
I duplicate the misbehavior with those changes simply by changing G10 (alternate between 2 and 3), which does not immediate demonstrate any misbehavior, change focus to another window, then return focus to the Excel window. At that point, the format is changed to Number with 14 decimal places.
Alternatively, change G10, then right-click on G10 and click on Format Cells. Again, at that point, the format is changed to Number with 14 decimal places.
(The number of decimal places depends on the magnitude of the value in G10. The format is changed to display 15 signficant digits. Change =2^G9 to =123^G9, which is 53.35+, and the format is changed to Number with 13 decimal places.)
I am able to duplicate this misbehavior with XL2010 on my unicore uniprocessor computer, but not with XL2007. So the formatting defect might have been introduced in XL2010.
I cannot duplicate this misbehavior on my multicore multiprocessor computer. But I only have XL2007 there.
The point is: I don't know if simply changing the window focus works on multicore multiprocessor computers.
