Have you tried with the tilde(~) as Jim Cone suggested?

Replace what: ~*12

With: ~*21


Gord

On Sun, 12 Nov 2006 06:00:02 -0800, Office Jnr
wrote:

Sorry had given up and went to sleep UK time.
The factor is a number. I know the easiest way would be to replace with a
cell as a multiplying factor and then always do th changes there But I am
using someone's spreadsheet and don't want to "step on their toes"

"4pinoy" wrote:

i dont know why it mostly freeze a question when i log in...? Are u still
there ?

"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


Gord Dibben MS Excel MVP