Deleting cell data without deleting formula
 

In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

--
remove .spoo to reply by email

Deleting cell data without deleting formula
 

A cell cannot contain data and a formula.

The formula is the actual cell contents, and what the formula is constructed
to return is what the cell displays.

If the formula depends on the contents of other cells (=A1+B1),
you could remove the data in those cells, unless ... of course ... if they
*also* contain other formulas.

If the formula is self-contained (=100+25),
then there is no way to remove the data without removing the formula.

SO ... exactly what are you looking to accomplish?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Tom Hall" wrote in message
...
In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

--
remove .spoo to reply by email

Deleting cell data without deleting formula
 

Can you clarify how you differentiate cell formulas from cell data when
referring to cell contents? An example would probably help.


***********
Regards,
Ron

XL2002, WinXP


"Tom Hall" wrote:

In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

--
remove .spoo to reply by email

Deleting cell data without deleting formula
 

If you have a worksheet with a mixture of data and formulae and want to clear
out the data, but leave the formulae alone then:

Edit Go To Special... and click Constants and then OK
this selects the data, but not the formulae
Edit Clear All
clears out the data
--
Gary's Student


"Tom Hall" wrote:

In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

--
remove .spoo to reply by email

Deleting cell data without deleting formula
 

On Sat, 28 Oct 2006 11:30:01 -0700, Gary''s Student
wrote:

If you have a worksheet with a mixture of data and formulae and want to clear
out the data, but leave the formulae alone then:

Edit Go To Special... and click Constants and then OK
this selects the data, but not the formulae
Edit Clear All
clears out the data

Thanks!

The others who replied pointed out a flaw in my thinking, but you've
actually given me what I was looking for.

Thanks again!


Tom

--
remove .spoo to reply by email