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