Lee

If C1 had a <space in it, you would get the error.

A <space would not be visible.

Try EditClearContents on C1

Gord Dibben Excel MVP



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.