Function Keys in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
F2 allows you to edit directly in the cell, do you have calculations set to
automatic under tools>calculations? 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 edit>replace and replace = with =


Regards,

Peo Sjoblom
 
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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

F2 key nonfunctioning 3
Recently lost function key settings in various software 2
excel cells changing to "#VALUE!" whenever another file is opened 8
f2 function key 4
F2 key 1
Convert Numbers to Text 4
Countif Conditions - Use of conditions that vary by cell value 1
Countif result problem 4

Back
Top