NEWBIE -clear all manually entered cells?

[Jenny]

Hi - Running Excel 2002 (2003 about to come) and need to know -- do I
need to create a macro to automatically clear all non-formula /
non-text cells on a sheet? i.e. any cells which have a manually
entered number I want to be either blank or zero. I've not seen any
built-in procedure for this. Thanks!

 

[excelmunkey]

Hi Jenny,

Edit-Go To (or F5) to access the Go To dialogue box. Click on Special
and select Constants (all cells who's values do not start with an equal
sign or contain a formula). The check boxes allow you to choose the
kind of constant you are interested in.

Cheers,
JF.