Hi Steved

Why not enter 200 in a empty cell
Copy this cell

Select the range and use EditPaste Special...Add

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Steved" wrote in message ...
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