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