You already have it.
Select the area you want to analyze and do
Edit=goto Special and select constants (add further restrictions if you
just want to clear numbers or just text or just text and numbers)
then do Edit clear contents.
--
Regards,
Tom Ogilvy
"BJM" wrote in message
...
Excel allows you to clear cell contents but it also clears formulas. We
sometimes need to clear cells to produce mockup copies of financial
statements that need to be blank in order to enter new numbers from year
to
year. Too much time has to be spent in determing which cells have
formulas
(which we want to keep) and which do not. We need another option to
accomplish this. We use Microsoft Office Excel 2003.
----------------
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.
http://www.microsoft.com/office/comm...el.programming