----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
=Sheet1!A1+sheet1!b99
may become
=if(sheet1!a1+sheet1!b99=0,"",sheet1!a1+sheet1!b99)
But once you put in a formula, it's gonna have to evaluate to something...
--
Dave Peterson
Edit>Clear Contents.
Gord Dibben MS Excel MVP
PS: My idea is for the "Edit" menu have a "Delete Special" or something like
that so users can decide do delete everything (values, formula, formatting)
or any one or two of the 3 characteristics of a particular cell.
Unfortunately MS only allows upto 10 or so words per suggestion which is a
little skimpy if you ask me. Maybe what I'm asking violates some law of
physics. Maybe the programming language necessary for accomplishment of my
idea has not been invented.
If you don't want to see the value returned by a formula, I suppose you
could use the same color for the cell text and cell background.
2. F5>Special>Constants where you will have the four options to check or
uncheck.
Usually you would uncheck Text because you want to keep Titles etc.
3. Hit OK which will select cells with data from which your formulas derive
their values.
Edit>Delete and your data will be cleared, leaving the formulas intact but with
no values.
Experiment a bit until you get the correct combination.
Always best to do this on a copy of the sheet.
Gord