On Mon, 2 Feb 2004 11:08:36 -0800, "lee" wrote:

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.

Since IsBlank returns False, what do the formulas

=CODE(C1)

and

=LEN(C1)

return?

-----Original Message-----
On Fri, 30 Jan 2004 15:16:06 -0800, "Lee"
wrote:

A "#Value" is shown in a cell with a formuka of "=1*C1"
where C1 has no visible value or character in there. If
put a "0" in C1, the "#Value" changed to "0." why?
thanks.

You say "nothing visible", but that doesn't preclude the
presence of
space character(s). Being text, those would be enough to
yield the
error value. (I assume that you've checked that there's
no formula
like ="" in there either? It wouldn't be visible in the
cell (unless
you were in edit mode), but would be in the formula bar
unless the
sheet is protected and the cell Protection property set
to Hidden.)

One way to check is the formula =ISBLANK(C1). If that
returns False,
then there's something in there whether you can see it or
not.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *