F2 allows you to edit directly in the cell, do you have calculations set to
automatic under toolscalculations? If not maybe your workbook is becoming
corrupt?
If you want to get the same affects in many cells you cen select the range
of formulas, then do editreplace and replace = with =


Regards,

Peo Sjoblom

"LPS" wrote:

Can someone please tell me what the F2 key does in Excel 2000? I have a
column of data which has been copied from Access 2000 into an Excel 2000
sheet. It is numeric data and when I use the "Countif" function on this
data, it doesn't calculate. However, if I press the "F2" function key in any
of the cells, something happens to the data so that the "countif" function
recoginises it. Can anyone explain what is happening here?

Thank you.
--
LPS