I can make it work easily, but I am interested in finding
out what's in there becasue there are a lot of these and
they are copied into excel from ACCESS output (I believe)
so I can eliminate the problem ealier on. Now, since I
can't attached the little example, I would just describe
it. Isblank will give false so there is something there
and I don't think it's a space. If I click my cursor at
the editing bar and click some other cell (without doing
any typing in the problem cell), all the formula using C1
works. Any idea? thanks.

-----Original Message-----
You probably have an invisible character in there. A
space or
something. Or your font COULD be the same color as your
background,
though if you see the '0' you enter than that's almost
definitely not
the case unless you have some kind of conditional
formatting on it.
Try doing a right click and "Clear Contents" - Pikus


---
Message posted from http://www.ExcelForum.com/

.