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

=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

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

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

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