changing the multipling factor on large spreadsheet
Jnr?
"David Biddulph" wrote:
But of course A12*12 becomes A21*21
--
David Biddulph
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I don't know if/why you are actually including the quotes and the * in your
replace, but try just entering the numbers alone.
Assuming formula is =A1*12
Replace what: 12
Replace with: 21
Replace.
Will now have =A1*21
Gord Dibben MS Excel MVP
On Sat, 11 Nov 2006 14:51:01 -0800, Office Jnr
wrote:
Yes I have tried this: eg in "A*12*" Find *12 Replace with *21 instead of
giving me A*21 it replaces the whole cell content with just *21
"Rookie 1st class" wrote:
Have you considered Find/Replace? in the edit menu?
"Office Jnr" wrote:
I would like to change all cells on a spreadsheet that contain a
number
multiplied by X to the same number multiplied by Y
|