Clearing a cell
=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
|