Maybe your data is not numeric?

Re-format all to General then copy an empty cell.

Select the range of data and Paste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Mon, 17 Jul 2006 11:06:09 -0400, I Maycotte
wrote:


I don't know why excel will not calculate even when I press F9 (for
manual calculation). I have to end up going to the formula bar,
clicking inside it and pressing enter for it to calculate. Does
anybody have a reasoning and/or a way to fix this? Thanks.

-- Isaac