ExcelBanter - Delete content of cell without erasing existing formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete content of cell without erasing existing formula? (https://www.excelbanter.com/excel-discussion-misc-queries/163032-delete-content-cell-without-erasing-existing-formula.html)

duethckey

Delete content of cell without erasing existing formula?

I copied a file.
I would like to erase the number in the copied cell but save the formula.
When I hit clear contents it also erases the formula??
Thx

Gord Dibben

Delete content of cell without erasing existing formula?

F5SpecialConstantsOK.

EditClear Contents

Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 10:02:01 -0700, duethckey
wrote:

I copied a file.
I would like to erase the number in the copied cell but save the formula.
When I hit clear contents it also erases the formula??
Thx

All times are GMT +1. The time now is 08:31 PM.