almost like - Edit- find "*12" - Replace all with "*21". When I do this
instead of keeping the figure that is being multiplied and multiplying it by
21 it i replacing the whole cell content with "*21" only.

"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