F5SpecialConstants. Checkmark what you want..numbers? and OK your way out.

Formula cells will not be selected.

EditReplace

what: 8
with: 9


Gord Dibben Excel MVP

On Fri, 22 Apr 2005 13:06:03 -0700, "ToddG"
wrote:

Is there a way that I can change all of the hard 8's entered into a worksheet
(not the 8's resulting from formulas) to all hard 9's without re-typing all
of the data?