R Rob Sep 29, 2003 #1 Hi- Is there a way to erase the contents of a cell without erasing its formula? Thanks
H Harlan Grove Sep 29, 2003 #2 Is there a way to erase the contents of a cell without erasing its formula? Click to expand... No. A cell's formula is its contents.
Is there a way to erase the contents of a cell without erasing its formula? Click to expand... No. A cell's formula is its contents.
L Leo Heuser Sep 30, 2003 #3 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? -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please.
H Harlan Grove Sep 30, 2003 #4 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.
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.
