Clearing a cell

B

basil

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
 
B

Bob Phillips

=IF(A1="","",A1)

--
HTH

Bob

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

challa prabhu

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
 
B

basil

Thanks Challa
Bob's fix works but your fix is the best for me as I have a lot of cells in
need.
 
Top