I have several ranges on several sheets which contain a mixture of
a) numbers in the form of: 123
b) numbers in the form of: =123+456 (resulting in 579)
c) formulae in the form of: =sum(A1:A20)
d) formulae in the form of: =A30+A40+A50 etc..

Each month I need to clear the numbers in categories a & b, but leave
the formulae in categories c & d

What's the simplest and quickest way of achieving this?

Is it a macro which loops through all the cells testing to see whether
the cell should be cleared, or is there a more elegant solution.

If a looping macro, can someone suggest what the test should be
please?

Many thanks,

Richard Buttrey