Nope. The space bar inserts a space, which is something and not nothing. You
should use the Delete key instead.

--

Vasant

"buddyorliz" wrote in message
...
The space bar is what I usually use to clear contents and it evently was
Not
clearing everything.
Thats what I'm saying, after I did that I could not see anything and there
should not have been Anything it that cell, No formula No data, nothing,
However, unless I use the clear contents comand, it is still countaing
every
cell.

So maybe something IS worng with the program?

"Tom Ogilvy" wrote:

One way is if you have a formula like

=If(True,"","")

then copy this cell and do paste special = values on itself to replace
the
formula.

Less likely:
Another is to clear the cell using the spacebar.

--
Regards,
Tom Ogilvy

"buddyorliz" wrote in message
...
Well, I thought they were empty, no formulas, no data...
I don't know what a zero length is, or how I got stings
Can you tell me how I would Know they were not empty?
Thanks for you help.

"Tom Ogilvy" wrote:

sounds like none of the cells are empty. Perhaps they have zero
length
strings or something similar.

--
Regards,
Tom Ogilvy

"buddyorliz" wrote in message
...
I am Not new to Excel. The simple Counta formula has just Quit
working. It
counts all the cells. Is this a new problem or does anyone know
what I
am
suppose to do?