Very curious! First, I more or less assumed that we'd be able to attach samples in private messages as well as here, but I don't see a way. Second, I did use <Ctrl-Shift-Enter>, and got the results I described.



In fact, I opened your worksheet, selected C13:C17, hit <F2>, then hit <Ctrl-Shift-Enter>—and the results changed to display 3049 in all five cells! I've attached the results. Out at the right I carefully pasted the formulae before and after my action; the formulae are identical, but as soon as I hit <Ctrl-Shift-Enter> (without changing the formula) it made that change.

So apparently either my copy of Excel isn't doing something right, or more likely I'm not doing something right. Can you think of some pointed questions that'll help me figure out what?

Oh, and just in case, I closed that worksheet and reopened it; still the same value in all five cells.

Attached Files

x.xlsx (11.4 KB, 13 views)