Formulas

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi-

Is there a way to erase the contents of a cell without
erasing its formula?

Thanks
 
Maybe it will suffice to format the contents of the cell
with the same color as the cell interior?

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Maybe it will suffice to format the contents of the cell
with the same color as the cell interior?
Click to expand...
...

In that vein, using the custom number format ";;;" would be an alternative.
Neither would prevent display of cell contents in the formula bar. Neither would
be treated as nonblank cells in formulas or cell pointer movement.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to save a copy of a wksht. but without any of the formulas 5
can a cell be both input and output? 2
how to clear data 3
Memory Stick 4
Excel Formula 2
manually edit a cell with a formula 1
Can a formula display output to an otherwise blank cell? 2
Panasonic PV-L780 camcorder-erase tapes 0

Back
Top