I just "cleared" all formats, then tried it, and it still didn't work. Then
I copied and pasted the data only into a new sheet, and it worked!!

Not sure what this is all about, and it must have something to do with
formatting of cells, but in any case, thanks for all your help!

I'm set - for today anyway. :-)

Mary

"Andy" wrote:

Hi

The only other option I can think of is that the cell is formatted as Text
before you enter the formula. You would need to change the format to General
and then re-enter the formula.

Andy.

"NewKid" wrote in message
...
Thanks! It is only the COUNTIF function that does this. All my other
functions and formulas are displaying normally. Also, MOST of the time,
this
doesn't happen, but every once in awhile, it just does. I have formatted
to
general, BUT usuallly the account numbers in these columns are preceeded
by
zeros and when I format to General and recalc, it drops the first zero...

I have also "cleared" the formats, but that doesn't seem to do it either.
Do you think it could be something silly like my worksheet is just so
large
(I frequently have 40,000 plus rows and at least 100 columns.)

Thanks again. Any further ideas are appreciated.
Mary

"SteveG" wrote:


Is it only the COUNTIF formula that shows up as text or does any formula
show up as text? If any formula shows up as text than the cell you
entered the formula in was probably formatted as text prior to entering
it. Delete the COUNTIF formula and check that cell's format. If it is
Text then change it to General and re-enter your formula. If it is not
text then check under Tools/Options/View Tab to see if in the Window
View area the check box next to formulas is selected. If it is, all
formulas in your sheet will be visible and not their results.

HTH

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=495346