As far as I can tell, Excel treats a blank cell as zero(0) so =0 will
return 4.

Try it with 0 and see what occurs.


Gord Dibben MS Excel MVP

On Fri, 9 Feb 2007 21:19:31 -0000, "David Biddulph"
wrote:

In which case, if your cell looks blank but returns the 4, you've probably
got one or more spaces (or other invisible characters) in a text string in
B7. What does =LEN(B7) give you? If it doesn't return 0, go into B7 and
delete the spaces or whatever is there.