Thanks Challa
Bob's fix works but your fix is the best for me as I have a lot of cells in
need.
"challa prabhu" wrote in message
...
Hi,

Do the following:

1. On the Tools menu, click Options.
2. In the Options dialog box, click the View tab.
3. Under the Window options, click to clear the Zero value check box.
4. Click OK.

Challa Prabhu


"basil" wrote:

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