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! *