Highlight cells,== Edit.. Replace, ==Find What: 4, Replace with : 6,
==Replace All.

HTH

"Steved" wrote:

Hello from Steved

I have 5401 to 5499 and need it to be 5601 to 5699 please

If there a formula I can use to acheive the above.

Thanks