Hi,
Thanks for that. Yes I was just copying the formula not the cell and now
doing it correctly it works just great. Thanks heaps!
Sue

"JE McGimpsey" wrote:

First, make sure Calculation is set to Automatic
(Tools/Options/Calculation)

Second, make sure you're copying the entire cell (not just the formula
in Edit mode). XL will automatically adjust the formula so that you get:


G21: =LEFT(G1,3) & TEXT(RIGHT(G1,3)+2,"000")
G41: =LEFT(G21,3) & TEXT(RIGHT(G21,3)+2,"000")
G61: =LEFT(G41,3) & TEXT(RIGHT(G41,3)+2,"000")


In article ,
Sue wrote:

I copied G21 to G41 and got:
G21: 06/003
G41: 06/003
G61: 06/003
I copied O1 to O21 etc and got:
O21: 06/002
O41: 06/002
O61: 06/002
and so had to alter the + no. afterwards.
I have double checked your instructions and redid it all again but still got
the same answer. Excel does not seem to be recognising that it has to move
the numbers on.
What am I doing wrong?