Hi,

I copied some info from a database and pasted it to Excel where I wanted to
manipulate the data. I notice that some of the cells, though appearing to
be blank (and not showing 0 either), still responded to a simple formula
like IF(OR(A1="",A1=0),1,0) giving the answer as 1.

Can anyone tell me what's happening here, as it does mean I need to
unneccessarily extend the formulas to exclude these cells.

Rob