In a worksheet there at least a 1000 cells containing the formula = Cell
reference*6.23 where cell reference is A1 , A2 , A3 etc.

I wish to change the value 6.23 in these formulae to 6.30 by using Find and
Replace.

If Find what = *6.23 and Replace with = *6.30 the formula in each cell
disappears and the contents of each cell becomes *6.30.

I of course could use

Find what = 6.23 and Replace with = 6.30 - this works but unfortunately
changes any cell value containing 6.23 in the worksheet which I wish to avoid.

Any suggestions please ?

regards

Flynne
--
FLYNNE