Thread: Clearing a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default Clearing a cell

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