It is like "A*6.4" and i want to change this to "A *13.5", but the figure A
varies in many other cells. I want to keep the figure A but find and replace
all is replacing with *13.5 only.


"4pinoy" wrote:

1. Do all cells that contain a number is obtained under a formula ?
2. How many times do you use the Factor X in one formula ?

"Office Jnr" wrote:

Yes


"4pinoy" wrote:

do you mean you need to REPLACE your factor X into factor Y?

"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