R
Rob
Hi-
Is there a way to erase the contents of a cell without
erasing its formula?
Thanks
Is there a way to erase the contents of a cell without
erasing its formula?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harlan Grove
Is there a way to erase the contents of a cell without
erasing its formula?
No. A cell's formula is its contents.
L
Leo Heuser
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.
with the same color as the cell interior?
--
Best Regards
Leo Heuser
MVP Excel
Followup to newsgroup only please.
H
Harlan Grove
...Maybe it will suffice to format the contents of the cell
with the same color as the cell interior?
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.