=if(A1=0,"",A1)

or to cover null,

=if(OR(A1=0,A1=""),"",A1)

"Jim" wrote:

If I have B2 referring to A1 and A1 has no data, how do I write this so that
B2 is blank instead of showing a zero?

Thanks for the help