F
FLYNNE
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
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