Function Keys in Excel
 

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

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

F2 followed by enter makes excel reevaluate your entry.

It sounds to me like your numbers are coming into excel as text. (Maybe
leading/trailing spaces are kept??)

I don't know anything about Access, but Debra Dalgleish as a vba routine that
fixes this at:

http://www.contextures.com/xlDataEntry03.html#Program

And she includes a note that xl2002SP3 fixes this kind of problem (well, read
that KB article to get the real info!)

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

--

Dave Peterson