Thank Bob works great.
"Bob Phillips" wrote in message
...
=IF(A1="","",A1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"basil" wrote in message
...
Hello
I would like to clear a cell to blank (no zero showing) from another
cell, just as if I had moved to the cell and pressed the del key. Every
thing I try leaves a zero in the cell.
TIA Basil